Rows Grouping is broken when changing order of columns when some columns are hidden?
Rows Grouping is broken when changing order of columns when some columns are hidden?
Hello,
I am working with datatables and using rows grouping option.
In fact, the row grouping depends on the values that exist on the columns by displaying: column name: value.
The feature works fine when all columns are displayed (rows grouping maintains the good values when performing sorting columns).
But when I hide some columns of my datatable (using ColVis option) and apply the sorting in any column of the grid, the grouping values change by taking values from other columns.
For example:
When displaying the grid with the following columns (the grid contains many other columns which are hidden), the Grouping of rows works fine: it groups by the values of Urgency column
ID Title Urgency Number
Urgency: * None *
1 TEST 1 * None * 60000
2 TEST 2 * None * 65485
Urgency: High/Yes
3 TEST 3 High/Yes 60045
4 TEST 4 High/Yes 65455
Urgency: Low/No
5 TEST 5 Low/No 70000
6 TEST 6 Low/No 67775
Once I sort the grid by any column (ID or Title or Urgency or Number), the rows grouping is broken and takes the following values:
ID Title Urgency Number
Urgency: Resolved
6 TEST 6 Low/No 67775
5 TEST 5 Low/No 70000
Urgency: in progress
4 TEST 4 High/Yes 65455
2 TEST 2 * None * 65485
Urgency: Opened
3 TEST 3 High/Yes 60045
1 TEST 1 * None * 60000
In fact when I sort by Title Column , the grouping takes values of a hidden column called Status (Resolved, in progress, Opened).
Any Idea ?