Question
Cognizant
IN
Last activity: 16 Sep 2022 6:39 EDT
Pega Reports
I have a requirement like this, where we need to run a report and fetch all the latest attempt cases., In one of the screens we are using table layout with source pagelist property.We can give mulitple entries, columns include, signature received(yes/no), attempt number.I have exposed pagelist property and created declare class with exposed properties.
Now the requirement is I need to fetch all the latest attempt cases where the signature received is No(A-1 and A-2 are not shown in output as signature is received in latest attempt.
Requirement:
|
case |
attempt |
sig received |
|
A-1 |
1 |
No |
|
A-1 |
2 |
No |
|
A-1 |
3 |
Yes |
|
A-2 |
1 |
No |
|
A-2 |
2 |
Yes |
|
A-3 |
1 |
No |
|
A-3 |
2 |
I have a requirement like this, where we need to run a report and fetch all the latest attempt cases., In one of the screens we are using table layout with source pagelist property.We can give mulitple entries, columns include, signature received(yes/no), attempt number.I have exposed pagelist property and created declare class with exposed properties.
Now the requirement is I need to fetch all the latest attempt cases where the signature received is No(A-1 and A-2 are not shown in output as signature is received in latest attempt.
Requirement:
|
case |
attempt |
sig received |
|
A-1 |
1 |
No |
|
A-1 |
2 |
No |
|
A-1 |
3 |
Yes |
|
A-2 |
1 |
No |
|
A-2 |
2 |
Yes |
|
A-3 |
1 |
No |
|
A-3 |
2 |
No |
|
A-3 |
3 |
No |
Output:
| Case | attempt | Sig received |
| A-3 | 3 | No |
Updated: 13 Sep 2022 5:24 EDT
Cognitonic Systems Australia
AU
@SushmaChidirala Write a report that retrieves data based on Max attempt(Summarize column in RD) and filter the results with filter value as No. Then you can get all the latest attempt cases with signature as No.
Regards,
Naga.
Cognizant
IN
@KotaC382I have tried this way, but first it is filtering with No, and then max attempt is applying. In that cases, it is considering the cases where the latest attempt is Yes also.(because in same case the before attempts will be No).