Group by field on Database view report

rajasekharteja
Tera Guru

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,

10 REPLIES 10

@rajasekharteja 

Sorry didn't get the point.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@Ankur Bawiskar  When I tried to do show matching with 'With Business Partner' status it's showing 'copy url to clipboard ' message.

@rajasekharteja 

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.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@Ankur Bawiskar Thanks for answering all the questions very patiently , Is there an alternate approach to achieve this functionality.

@rajasekharteja 

ask them to navigate to database view table and then handle the group by.

Example: incident_sla.list

AnkurBawiskar_0-1753970559624.png

 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader