Users cannot group multilevel pivot reports on tags.

Steps to Reproduce

  1. Create a new multilevel pivot report.
    • Set Table to Task [task].
    • In the Available column, move Tags and Assigned to to the Selected column.
  2. Click Run.
    Note the error message: Syntax Error or Access Rule Violation detected by database (Unknown column 'task0.sys_tags' in 'field list').



It is not possible to group reports on tags. Tags are stored in separate tables that are not part of the reporting platform. This restriction applies to the Columns, Rows, Group by, and Additional group by fields. The error displays either when you run the report or when you select Tags from the Additional group by control in a saved report.

Related Problem: PRB717670

Seen In

Eureka Patch 9
Geneva Patch 8
Helsinki Patch 2
Helsinki Patch 5

Intended Fix Version


Safe Harbor Statement

This "Intended Fix Version" information is meant to outline ServiceNow's general product direction and should not be relied upon in making a purchasing decision. The information provided here is for information purposes only and may not be incorporated into any contract. It is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at ServiceNow's sole discretion.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-06-15 06:33:40