How to filter report to show incidents from caller that is part of a certain group

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-24-2017 04:54 AM
We are creating a report which should show incident tickets opened by users that are members of a certain group (for example group named, "GroupX"). How can we do this similar to these javascripts on filter: javascript:getMyGroups() or javascript:getAllMembersOfMyGroups()
- Labels:
-
Incident Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-24-2017 05:35 AM
Hi Jimboy ,
Check the Business Rule OOTB Report Helpers. You may use part of it in Script Include to getAllMembersOfMyGroups
Then Create report and set filter like this:
Sys ID is javascript:yourScriptIncludeHERE();
Check this topic Using Script Includes to filter a report
Report Helpers | Global [global] | Defines a series of functions to help with generating reports:
|

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-24-2017 05:49 AM
Thanks for this. How would this work with the Assigned To field? It works on the Caller field, but not on Created by field.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-24-2017 07:44 AM
from the BR change var u = gs.getUserID(); to your requirement as you said to the current.created_by field or current.assigned_to .