Notifications
Announcements
No record found.
Hi All,
Could anyone please help me with finding unallocated cases. I wanted to find cases which were resolved or cancelled & later re-activated. As per CRM any case when re-activated is not assigned to any queue. How can I find out all those cases using fetch.
Hi Divya
There isn't an OOB case status reason for re-activated, but you could potentially add this and include the logic in your business process flow.
However, you could just use the following:
which will find all open cases that aren't in a queue.
Hope this helps.
Hi Alex,
Thanks for your response.
The fetch mentioned by you will not work for those cases which are re-activated & are not assigned to any queue. It will work only for those cases that are picked & remove from queue. I am looking after a solution to identify all those cases which are re-activated & are not assigned to any queue.
Hi
Good point, so agreed that a case that's been resolved will have already had a queue item.
My further suggestion is a bit more complicated and involves a combination of three additional fields on the Case:
Firstly a rollup field for the latest created date of a queue item:
Secondly a field for latest date the Case was resolved. This would need to be populated by a Flow or Workflow.
Thirdly, a whole number duration field for the differences between these:
This can then be used in your view.
Thank you for the response.
How about using modified on instead of creating second field. Could you please help me with this.
I have tried your above resolution. However, I am facing little difficulty with this.Could you please help me understand how with the difference of Timestamp in the third field I will get to know whether a case is assigned to any queue or not.
I'm assuming you've now got the flow or workflow ok? Let me know if not.
My understanding from what you've said is that a case will be assigned to a queue when it is new, so there will always be a queue items associated with a case.
The difference between the times will tell you whether the case has been assigned to a queue after it was resolved, which is what you want. Or from before the case was resolved.
Please would you mark this as Solved if your questions are now answered.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 35 Super User 2025 Season 2
Daniyal Khaleel 27 Most Valuable Professional
Soundari 15
