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
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.