ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: EPM Solutions on March 05, 2018, 08:07:32 am

Title: Sorting within the group
Post by: EPM Solutions on March 05, 2018, 08:07:32 am

Hi.

Is it possible to sort records withing the group without sorting the group headers? Say i have group 1 with 5 records and group2 with 3 records, on click on headers i want to sort only group 1 not group 2 when single: true?

group1
  record 1
  record 2
  record 5
  record 3
  record 4
group2
  record 1
  record 2
  record 5
  record 3
  record 4

Want to sort only group1 and final result is expected (ascending/descending)-

group1 (header1)
  record 1
  record 2
  record 3
  record 4
  record 5
group2 (header2)
  record 1
  record 2
  record 5
  record 3
  record 4

sorting of group headers is not expected.

Title: Re: Sorting within the group
Post by: paramvir on March 05, 2018, 10:48:24 am

Records are sorted in context of some specific field, your illustration is not clear enough to me.

Could you please provide an illustration from a live example.

Title: Re: Sorting within the group
Post by: EPM Solutions on March 05, 2018, 01:16:35 pm

Please find the below jsfiddle link.

http://jsfiddle.net/h4rmbx70/40/

We have 2 groups,  Group1 and Group2, on click Profits and Dept, rows withing the group are sorted which is expected but groups are sorting (asc/desc) is strange.

1. Our requirement is to keep Group1 always on top and sorted its rows asc. (click on Revenues field).
2. Is it possible to sort only Group1 rows, not Group2 rows. Currently Rows within the Group2 are also sorted.

Title: Re: Sorting within the group
Post by: paramvir on March 06, 2018, 12:13:49 am

Please let me know whether it works for you.

http://jsfiddle.net/h4rmbx70/65/

Code: [Select]

sortModel:{
      sorter:[ { dataIndx: "company", dir: "up" } ],     
      single: false,
      number: false,
      multiKey: null
    },


Title: Re: Sorting within the group
Post by: EPM Solutions on March 06, 2018, 08:03:26 am

Thanks for the solution.

As specified, we wanted it to be worked when single: true. Also when sorted, group 2 remain unsorted.

Title: Re: Sorting within the group
Post by: paramvir on March 07, 2018, 09:48:22 am

Sorry  I don't see any option to enable sorting on 2 columns ( first fixed one on group column i.e., company, and second on any other column ) with single: true. It works with single: false only.

Secondly it's not feasible to sort records in one group and ignore records in any other group. All the records are sorted.

I'm still looking for any available workaround to meet your requirements and would let you know as soon as I found one.