ParamQuery grid support forum

General Category => Bug Report => Topic started by: jim@solver.com on August 18, 2022, 05:24:16 am

Title: Group Sort not restored after multi-column sort is cleared
Post by: jim@solver.com on August 18, 2022, 05:24:16 am

I am currently using Pro version 8.5.0.

I have found an issue with group sorting not being restored to the original sort order after a multi-column sort is cleared.

I created a JSFiddle to demonstrate the issue using the following steps. https://jsfiddle.net/jhschmidt/bc8hmwo1/ (https://jsfiddle.net/jhschmidt/bc8hmwo1/)

• Run the JSFiddle demo
• Note that the order of the 'Name' column groups and the 'Position' column values are sorted because they are ordered in the JSON data
• Click the 'Letters' column header to sort by the letters column summary which is 'min'
• Observe that the rows are sorted correctly and the group order is now B, D, A, C, E
• Click the 'Digits' column header to sort the digits column summary which is 'min'
• Observe that the rows are sorted correctly and the group order is still B, D, A, C, E
• Click the 'Digits' column header two more times to remove the sort
• Observe that the rows did not return to the original letters sort order
• Click the 'Letters' column header two more times to remove the sort
• Observe that the rows did not return to the original sort order of the name groups and position values

Note: When the group is removed this sorting test works correctly.

I did some debugging and found that after Step 9. the internal pq_order sort is applied which the onCustomSortTree function uses. The group title rows do not have a pq_order property so the groups do not sort.

I hope this helps you track down this issue.

Thanks,
Jim

Title: Re: Group Sort not restored after multi-column sort is cleared
Post by: paramvir on August 18, 2022, 06:27:00 pm

Hi Jim

Thanks for sharing the steps, jsfiddle and debugging information :)

Looking into it.

Thanks
Param

Title: Re: Group Sort not restored after multi-column sort is cleared
Post by: paramvir on August 29, 2022, 05:27:30 am

This has been fixed in upcoming v8.6.0

Title: Re: Group Sort not restored after multi-column sort is cleared
Post by: jim@solver.com on September 08, 2022, 05:40:10 am

I tested the 8.6.0 version and the original sort order is returned after performing this test with nested JSON data. Thanks for the fix!