Reason behind group by option is disabled for a column in list control

[ramireddy]

Hi,

In list control, we have 10 columns. Out of those 10 columns, for 1 column, in context-menu, "Group by" & Other charting options are disabled. I would like to understand what is the reason behind this?

Thanks

Rami Reddy

[ramireddy · Accepted solution]

Hi Sergiu,

After playing with various column lengths, I understood that till 255, it allows "Group by" After that it won't allow "group by".

Thanks

Rami Reddy

[sergiu_panaite]

Yes, that's correct. The string fields over 255 characters are stored differently on the database side.

Regards,

[sach1]

Ram,

Grouping is not possible on string type of fields. Reference,Choice,Date/Time fields have unique value which ServiceNow can use to group.

Mark correct if you find it helpful.

[ramireddy]

Hi Sachin,

In same table, I have another string column with size as 100. I am able to "group by" based on that field.

Thanks

Rami Reddy

[sergiu_panaite]

Group by on string columns is possible. Group by on date/time is not possible.

Regards,