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

Fixed In

Jakarta Patch 10
Kingston Patch 8

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-05-21 11:38:33