Question
Sun Life Financial
CA
Last activity: 9 Jun 2022 21:50 EDT
Can we display cases count conditionally in a table of listed workbaskets
Hi Team,
we have a requirement specifies to list all the work baskets of an user default work group and list the cases count based on the update date time of based on time range.
| Work Basket Name | Case count updated today | Cases count updated yesterday | CC b/w 3 to 7 days |
|---|---|---|---|
| Work Basket1 | 3 | 2 | 4 |
| Workbasket2 | 4 | 3 | 8 |
Here, using date time difference we achieved the logic using a RD built in Assign-WorkBasket class with a condition Workgroup equals to user work group and no other joins added.
Now the additional requirement is that for each row we are expecting the cases count a specific status. For example. WorkBasket1 row should display the count of cases in "waiting-for-approval" status and Work basket2 should display of the cases with "Resolved". Any thoughts much appreciated.