32 views

Symptoms


When using Aggregation Average in a report, a user/admin may run into the error: 

      Syntax Error or Access Rule Violation detected by database (Unknown column 'avg_of_xxxxxxxxxx' in 'order clause')

 

 

Cause


This error may be caused because the "Aggregated Field" on the report may not be an pointing to an actual field.

***Both the New UI and Classic UI***

 

Resolution


The user/admin will need to drill down one or more times in the "Aggregation Field" until a field is selected.

Ex) SLA definition -> SLA Definition fields -> Duration

  

 

 

Article Information

Last Updated:2018-10-10 16:40:01
Published:2018-10-10