book
Article ID: 185947
calendar_today
Updated On:
Issue/Introduction
Group by not showing my Custom Field. We have a custom field and it is visible as a column in Work Views, however we do not see it in the group by list. How can we add it to the group by list?
Resolution
Custom field types 'Drop Down' and 'Drop Down (User)' are the only custom field types that allow Group By functionality.
The reason for this is performance. Drop Down and Dropdown (User) have a finite number of options that are defined in the setup of the custom field. With a String or Text field the possible grouping options are nearly infinite (combination of alphabetic, numeric, special characters, accented characters, etc.). To evaluate all possible combinations would be a huge performance impact and would lead to a bad user experience.