- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-07-2025 05:21 AM
I'm looking for a way to create a report of RITMs where the owner of the RITM does not own any of the catalog tasks (SCTasks). I tried using [sc_req_item] as the table and dot walking to assigned to and that didn't work. I tried from the RITM and Task table and those didn't work. Anyone have any ideas?
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-07-2025 06:02 AM
Is this what you mean? Basically, you want all active RITMs where the Assigned to person in the RITM doesn't have any tasks Assigned to them?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-07-2025 06:28 AM
Thank you both for responding so quickly. AG - I tried going from SCTask but that didn't work. Jennifer, I'm looking to see people who own the RITM but don't' have any tasks associated with that RITM. They own the Requested Item, but don't have to do any of the work). So I tried your way without success, I also tried flipping the condition to "is different from" but that also didn't work.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-07-2025 11:07 AM
What do you mean by "own"? If you don't mean assigned to, then you would need to change that field. I made the assumption you meant Assigned To since there isn't an "Owner" field on RITMs.