How to configure a Group By when we open an Table?

[Santosh Oraon]

Hello Team ,

I have a requirement that whenever I open a Table like Example - Incident LIST view  then in List view Rrecords will be shown groupby Assigned To user.

[AndersBGS]

Hi @Santosh Oraon ,

I don't this is possible, as incident.LIST is OOTB and not something that you should try to change. What is the business requirement for your question? And have you considered creating a dashboard with the specific report on it instead?

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[Tai Vu · Accepted solution]

Hi @Santosh Oraon 

If you're working with Navigation Menu, you can set the Group By in the Arguments field. Using this syntax.

sysparm_query=GROUPBYstate //replace state by your field name

Sample.

Ref: KB0714231 - Group the records in the List view by default on clicking a module in navigation bar

Resolution

1)In the nav bar, search for System definition --> Modules and select it. 
2)In the list, filter the table(example: Incident) and the module title(example: All) where you want to group the list and open it 
3)Under the Link Type tab, select URL (from Arguments:) in the Link Type field 
4)In the Arguments field, paste the below value 
incident_list.do?sysparm_query=GROUPBYstate&sysparm_first_row=1&sysparm_view= 

This will group the incident table list by State for 'Incident --> All' module

Cheers,

Tai Vu

[Santosh Oraon]

Thanks @Tai Vu  for this small help!!!

[Dr Atul G- LNG]

Hi @Santosh Oraon 

Group the records in the List view by default on clicking a module in navigation bar

Resolution

1)In the nav bar, search for System definition --> Modules and select it. 
2)In the list, filter the table(example: Incident) and the module title(example: All) where you want to group the list and open it 
3)Under the Link Type tab, select URL (from Arguments:) in the Link Type field 
4)In the Arguments field, paste the below value 

incident_list.do?sysparm_query=GROUPBYstate&sysparm_first_row=1&sysparm_view= 

This will group the incident table list by State for 'Incident --> All' module