What are the types of fields that can be grouped by in list and what cannot be grouped by?

Rain Vaine
Kilo Sage

Hello experts,

I just want to know if you have any resource or documentation links on what are field types that are in default can be grouped and which cannot be grouped?

I just found that some field types cannot be grouped by in a list like the date, datetime and list type of fields but I cannot find a documentation on a list of all the types of fields that cannot be grouped by and can be grouped by default.

Regards, 
Vaine 

4 REPLIES 4

Mayur2109
Kilo Sage
Kilo Sage

Hi @Rain Vaine ,

 

In a list view you cannot use the "Group by" functionality on columns if the String type if their maximum lenght is greater that 255 characters. The "Group by" context menu item is greyed out.

Refer below kb article for more understanding.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0715905#:~:text=In%20a%20list... 

 

Please check and Mark Helpful and Correct if it really helps you.

Regards,
Mayur Shardul

Hello,
I also already found this article but what I need is a list of of field types.

Regards,
Vaine

Hi @Rain Vaine ,

 

As per my understanding field types Collection, List, Time/Date, Journal, Journal Input/List, User Input doesn't allow group by on list view.

 

Regards,

Mayur

 

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Rain Vaine 

 

I think , doc shared by @Mayur2109 is only available and your comments also right Dates / journal field type like comments/ work notes can be group by. 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************