
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-03-2023 07:10 AM
Need to find a way to show RITM records that have no tasks created against them. We had a BR fail for creating requests/RITMS without tasks being created even though the flow designs had tasks.
We have since fixed that issue but we just want to ensure that there are no open RITMS with No Tasks lingering out there
I tried creating a report based on the requested item table with the related list condition of Catalog Task -Requested Item but that did not return the correct records - it returned the RITMS WITH tasks, not without tasks.
Thanks
Solved! Go to Solution.
- Labels:
-
Service Level Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-03-2023 09:26 AM
@tery ,
I tried to create a report on sc_req_item table and under filter, we have an option "Related List condition" select that as equal to 0 and the table can be Catalog Task Request Item, I was able to fetch a report of RITM's that did not have an task
Hope this helps!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-03-2023 10:37 AM
Would it be possible to share the screenshot of the filter conditions?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-03-2023 10:37 AM
I got it now - changed the valude in the Related List Conditions to Less than or Equal to 0 and only got back RITMS with no tasks!
Going to create/run in Production now where there are some records like that.
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-03-2023 10:41 AM
Glad it worked! Please do mark my response as helpful/correct if it resolved your query..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-30-2024 05:01 AM
I had no idea you could do this. It's a shame I can only give you one Helpful!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-30-2024 07:21 AM
Awe thanks.
I try to post stuff when I can especially if I think it's unique and others may use it...