Group By: When using Show Total Rows and you group by the last column with aggregations defined, you get an error
search cancel

Group By: When using Show Total Rows and you group by the last column with aggregations defined, you get an error

book

Article ID: 265947

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

On a grid where the option to show 'Totals Row' is enabled and the last column in the grid is a field that can have value aggregations (for example, the 'Active' field), the user should be able to use that last field as the 'Group By' field and have the grid work as expected. 

Steps to Reproduce: 

  1. Go to projects workspace 
  2. Switch to grid and have the following columns: Name, ID, Manager, Active (Note: Name, ID and Manager attributes no aggregation is set) 
  3. Now in the View options, enable Show Total Rows 
  4. Notice the Total row appears first on the grid and Active has the total number 
  5. Now Group By Active 

Expected Results: The grid should work as expected. 

Actual Results: The message 'Could not load rows' is displayed and the grid is empty. 

Workaround: Refresh the page, or add another column to the layout which forces a refresh to the page. 

Environment

Release 16.1.2 

Cause

DE69820 

Resolution

Targeted Fix in Release 16.1.3