Group By in related lists
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-22-2014 02:31 PM
Is there a way to get the same view in related lists as we get when we do a 'Group By' on certain column on list page?
- Labels:
-
Service Mapping
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-22-2014 07:25 PM
I guess you can. Try these links
Couple of functions here you can make use of
http://wiki.servicenow.com/index.php?title=GlideList2_(g_list)#setFilterAndRefresh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-23-2014 12:00 PM
Related lists have limited functionality compared to usual lists. For example, you can sort but cannot group records. Nor can you export data from a related list. A quick workaround is to right-click the breadcrumb and select "Open new window" from the context menu. A new browser tab/window will open with the same list, and the filter will also be preserved. There you can group the records and also export them.
Blog: https://sys.properties | Telegram: https://t.me/sys_properties | LinkedIn: https://www.linkedin.com/in/slava-savitsky/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-24-2014 12:33 PM
On another note, if the grouping is fixed on a small amount of values, you can try to create a related list separately for each value.
For example, if you have change_request that has several child incidents, but you want to group by incident_state, you can create, say, three related lists:
1. New and Open incidents
2. Incidents in Awaiting
3. Resolved and Closed incidents
You would create a specific relationship for each with the table and filters and then add them to your form.
Creating Defined Related Lists - ServiceNow Wiki
Just my two-cents on how I have handled a few of these
