- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-22-2018 08:08 AM
Hi there,
Is there a way to create a report which shows list of Requests which don't have any Catalog Tasks assigned?
In Catalog Task table I have "Request" reference field, which is filled with Request number if Catalog Task is created under a Request.I don't have similar field on Request level, as this is "many to one" relationship, and in fact Requests are not related to Catalog Tasks. Is there a way to use a script or something to get a report which contains required information?
Solved! Go to Solution.
- Labels:
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-22-2018 10:27 AM
Just to clarify, are you talking about a report of requests (REQ) that have no catalog tasks, or a report of requested items (RITM) that have no catalog tasks?
Either way, you should be able to create a report on it using the new report designer that was rolled out in Istanbul, if I recall correctly. Just create a related list query against the catalog tasks related list with the qualification of having no items.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-09-2025 03:27 AM
HI Kuba4,
Could you please tell me the condition of the related list?
