Group By name in the list view is not coming to all fields

[Rakhesh]

Hi All,

I'm facing an issue with the group by in table list view. We have a custom table, in list view, I set to group by to all fields in the list view expect one field. why I'm not able to set to group by for particular field on list view.

briefly, please find below Screenshot for clarification.

Can anyone knows please guide me to achieve this.

Regards,

Rakhesh

[Giles Lewis]

It may be based on the field type. You can always group by a choice or reference field, but you cannot group by a string field if it is too long. If possible make it a choice field.

[Ankur Bawiskar · Accepted solution]

Hi Rakhesh,

ServiceNow does restrict group by based on type of field. It allows for example: reference, drop down, etc

Grouping is not possible on string type of fields(with length more than some limit). Reference,Choice,Date/Time fields have unique value which ServiceNow can use to group. It supports fields that holds a single value.

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur