Reporting with Members of a Group

[Maria20]

I created a report off the Task table to get all open tickets. 

I want to include all tickets that have been assigned to members of certain groups.  The Assignment Group field is not consistently filled in so I have to rely on whether the Assigned To value is a member of the group. 

I've tried dot walking but with no success.  Any ideas?

[Gaurav Bajaj · Accepted solution]

Hi,

You can create a dynamic filter to check that the user (assigned to) is part of that specific group or not.

This would need a script include, a dynamic filter option and you can use it as a filter on your task table.

Let me know if you need help with the script.

https://www.servicenowguru.com/system-definition/harnessing-power-dynamic-filters-servicenow/

This link has a great example of the same objective.

Please mark it correct/helpful based on the response.

Thanks
Gaurav

[Community Alums]

I need a complete script and dynamic filter. Please do needful 

[Maria20]

Hi Gaurav,

Thanks for the reply.

I'm relatively new to ServiceNow...so I appreciate the help!

I created the Script Include as instructed but I don't think it is returning anything.  Is there a way to check what is being returned by the script?

I also created the Dynamic Filter and was able to select it as a filter in my report, so that part is working.

Maria.

[Gaurav Bajaj]

You can add logs to return statement by using gs.info & print some values to see.

Are you looking for just one assignment group or multiple here?