Report Requests which don't have Catalog Tasks assigned

[kuba4]

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?

[Dennis R · Accepted solution]

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.

[Adam Stout]

Related List Conditions seem to be the way to go.  Here are some examples to get you going:

Make Complex Reporting Easier using Query Techniques

[Josh Cooper]

If you don't have access to Related List Conditions (which are in List v3, and may not be enabled if your instance is older, or has been around for a while) then you can also build a Database View from Request to Catalog Task, for Where condition, it's where the Catalog Task.Request = Request.sys_id - and put Request to Left Join, then you should be able to report where "Catalog Task.Number" is empty, or something similar.

[kuba4]

This functionality with Related List condition works perfectly fine for me. Thank you very much for your support ! 🙂