Requested Item view filtering to the related Task level

[Ben Wilcox1]

Looking for a way I could set up a list view in the Requested Items table or do this via Report that would show if related tasks are present.  Particularly, I'm hoping for a way to filter to see RITMs that have one or more tasks associated with them that are assigned to a particular Group. 

There doesn't appear to be a way to dot walk in that direction.  You can look upward from the bottom (at the Task level) to see the relations of the RITM to the Task (and do things like add the "Parent" field to the TASK view and see the related RITM number), but there doesn't seem to be a way to "see" the related Tasks in an Requested Items list view to be able to do such a filter against. 

Wondering if an additional table would need to be created to accomplish this.

[Michael Ritchie · Accepted solution]

List v3 allowed you to do this but it was deprecated with the London release:

https://docs.servicenow.com/bundle/london-platform-user-interface/page/use/using-lists-v3/task/creat...

There were some performance challenges with it.

Another way to accomplish this is with a database view where you join the sc_req_item to the sc_task table allowing you to filter on all columns.

https://docs.servicenow.com/bundle/london-platform-administration/page/use/reporting/concept/c_Datab...

[Ben Wilcox1]

We haven’t upgraded yet, so the related lists function worked perfectly.  However, we’ll be upgrading next year, so the other option is what it looks like I’ll need to do long term.

Appreciate the quick response!

[Michael Ritchie]

If you have the plugin activated before the upgrade you will be grandfathered to use it.  London doesn't allow new installs of it.  I would be selective with it as you can enable it for certain lists just to be safe.

Please mark any post as helpful or the correct answer to your question if applicable so others viewing may benefit.