Custom Sorting Logic: Reset Sort Order Every N Rows

Custom Sorting Logic: Reset Sort Order Every N Rows

Posted by: gnajarro on 3 March 2025, 12:27 pm EST

• 

  gnajarro

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 3 March 2025, 12:27 pm EST

  Hello team, i would like to know if its possible to reset sort every N rows per column?
  
  example would be:
  
  in Value column in normal sorting it would look like this (1,2,2,3,3,4,4,5,6,7,7,8) as it would sort all the data inside that column, however what we would like is for the data to be sorted as ascending/descending every N rows in here every 4 rows. so every 4 rows it would reset back and find another ascending/descending value in that 4 row.

  1,2,3,7
  
  2,4,5,8
  
  3,4,6,7

• 

  sonu.pandey

  

  • Post Options:
  • Link
    Copy

  Posted 4 March 2025, 7:53 am EST

  Hello,

  The sorting in FlexGrid is done based on the data in that sorting column. If you wish to change the default sorting behavior in FlexGrid, then you may use the sortComparer or sortConverter properties of the CollectionView and provide your sorting logic to it. You can refer to the below API link for more information :

  https://www.grapecity.com/wijmo/api/classes/wijmo.collectionview.html#sortcomparer
  
  https://developer.mescius.com/wijmo/api/classes/Wijmo.Collectionview.html#sortconverter

  Regards

• 

  gnajarro

  • Post Options:
  • Link
    Copy

  Posted 4 March 2025, 4:12 pm EST

  Hello, @sonu.pandey

  Is it possible to modify the sorting logic of the FlexGridFilter filter editor? in the ascending and descending buttons from showSortButtons? i can’t see any implementation on it, i would like to see some steps on how to do it.

  thank you for responding to my previous question.

• 

  vivek.pannu

  

  • Post Options:
  • Link
    Copy

  Posted 5 March 2025, 7:11 am EST

  Hi gnajarro,

  It seems you have also created a new post for this query, we have shared the required information on the same. Here’s the post link for your reference - https://developer.mescius.com/forums/wijmo/ascending-descending-button-custom-sorting-in-flexgridfilter-editor

  Here’s a copy of the response -

  *Yes, it is possible to customize the default sorting function of ascending/descending buttons sort buttons in the filter editor. There are two properties available on the collection view that you can use to change the sorting behavior, i.e. sortComparer, sortConverter. To completely replace the default sorting function with a custom function you can use the ‘sortComparer’ property. You can refer to the API links for more information -
  
  https://developer.mescius.com/wijmo/api/classes/wijmo.collectionview.html#sortconverter
  
  https://developer.mescius.com/wijmo/api/classes/wijmo.collectionview.html#sortcomparer

  Here’s a sample for your reference demonstrating the same - https://jscodemine.mescius.io/share/6GPeSOrYHEmov55A8CWx1A/*

  In case, you face any issues, please let us know.

  Regards