Report on list field

[Community Alums]

I have a table with a list field where I want to group on values.   However, I have read you cant report on this because these fields are an array of sys_id's, meaning one could show as A B C and the other could show as C B D.

I want to be able to report on this table to say something like, where records contain value "B", and then group by these values.   Is this possible?

[Saikiran Gudur1]

Hi Josh,

I did not try this till now but I expect it should work when you do it via a background script with CONTAINS query on that field.

[Community Alums]

pradeepksharma ctomasi

[Pradeep Sharma]

Thanks for the ping Josh. You are right. Grouping on list field is not supported. However, I found a workaround in the below thread i.e you can add a Dictionary attribute to a glide_list field: can_group=true. Please refer the below link for more info.

Are glide lists groupable in reporting

Enhancement requests: Using HI to tell us how you would improve the ServiceNow product

[Community Alums]

Thanks Pradeep.

Another suggestion I saw is to have a business rule that auto alphabetizes the choices on insert so they will group more consistently.

Do you have an example of this?