Group by field on Database view report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-31-2025 03:55 AM
Hello All,
I got a requirement where I need to create a report using Task state metric(metric) table and a_resource_task table I have created Database view report using two tables and provided access to Team lead users, now users should be able to do group by status and export specific tasks state records.
How to can we do group by on database view report(list) for task state.
Thanks,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-31-2025 06:09 AM
Sorry didn't get the point.
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-31-2025 06:23 AM
@Ankur Bawiskar When I tried to do show matching with 'With Business Partner' status it's showing 'copy url to clipboard ' message.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-31-2025 06:28 AM
on report you can't use Right click -> Show Matching
That option doesn't come at all.
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-31-2025 06:37 AM
@Ankur Bawiskar Thanks for answering all the questions very patiently , Is there an alternate approach to achieve this functionality.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-31-2025 07:02 AM
ask them to navigate to database view table and then handle the group by.
Example: incident_sla.list
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader