Grouping by a reference field in a report or list view on a database view shows (empty) for all groups - Known Error

Grouping by a reference field in a report or list view on a database view shows (empty) for all groups Description When creating a report on a database view, grouping by any reference field shows (empty) for all groups on the report. This occurs regardless of the joins on the database view (occurs even when there are no joins) and regardless of the table(s) in the view.

Steps to Reproduce

Steps to reproduce ( Report ):

Create a new database view. Add the [task] table to the database view (Where clause is not necessary). Create a new report and select this database view as the table. Choose the Bar report type. Group by 'Assigned to' (or any reference field) Run the report. Notice that all groups show (empty) even though the aggregated totals are correct Steps to reproduce ( List View ):

Complete steps 1 to 2 from above. Open the list view for the database view. Personalize the list to show 'Assigned to' (or any reference field). Right click the column header for Assigned to and select Group By Assigned to. Notice that all groups show (empty) even though the aggregated totals are correct. Workaround As a workaround, change the prefixes used in the database view to be lowercase.

After careful consideration of severity, frequency, and risk, this issue will not be addressed in current or future releases. ServiceNow does not make these decisions lightly, and apologizes for any inconvenience. ServiceNow Technical Support can be contacted for further questions regarding this issue.