Reporting on Catalog Tasks Opened by "Me" Assigned to A Group That is Not One of "Mine"

[Kieron Jones]

Hi All,

Having a real problem with this one.

As the subject suggests, I would like to report in ServiceNow, on catalog tasks (sc_task) where the assignment group is not one of mine. In other words where the user of the report runs the report, and can see a list of all tasks that have been created by them, but for a group outside of any that the user is a member of.

I can't seem to find quite the right filter condition, as the IS NOT does not work on DYNAMIC groups, and clearly, I cannot just provide a list of groups.

The report has to work for ANY user, so I cannot use my own name in the filter.

Driving me nuts!

Thanks for your help!

[Mike_R · Accepted solution]

try this

instanceName.service-now.com/sc_task_list.do?sysparm_query=assignment_group!%3Djavascript%3Ags.getUser().getMyGroups()&sysparm_view=

[Kieron Jones]

Thanks again. Spot on! That worked.