Close popover
Subhajit Chattopadhyay (SubhajitChattopadhya)
Infosys Australia
Lead System Architect
Infosys Australia
SubhajitChattopadhya Member since 2010 36 posts
Infosys Australia
Posted: February 12, 2020
Last activity: February 17, 2020

Report for retrieving the list of cases with no assignments

Hi Team,

I want to have a report that pulls up cases where the assignments have got removed due to some error and they are not resolved. 

Here is the approach I have taken. I have created a report definition on the case type class and tried pulling the case IDs, created operator and few other fields. I have done a join on Assign-Worklist and Assign-WorkBasket classes by checking that our pzInsKey in our case type class in not present in both of those classes.

When we run the report, we see it is not pulling any cases where there are numerous cases that are present.

Any solution recommended will be highly appreciated



Reporting Lead System Architect
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.