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.