List view of open requested items with no open catalog tasks associated to the requested item.

[Community Alums]

How to know if a requested item has open catalog tasks or not, how to build the filter condition. I want to see the list of requested items with all closed catalog tasks.

[James Chun]

Hi @Community Alums,

Not sure if I understood the requirement correctly, but you can create a Report with Related Conditions - https://docs.servicenow.com/bundle/washingtondc-platform-user-interface/page/use/using-lists-v3/task/create-related-list-query.html

Something like the following

Cheers

[Community Alums]

Hi @James Chun - It doesn't work when there are multiple catalog tasks associated with a single requested item. The report show results even one task from the requested item record is closed. I want only the list of requested items where all the catalog tasks are closed.

[James Chun]

Hi @Community Alums,

You can change the Quantity value of the related condition to something like:

And change the condition to Active = True