FlexGrid column filtering / sorting

FlexGrid column filtering / sorting

Posted by: stuart-palmer on 14 September 2017, 3:14 am EST

• 

  stuart-palmer

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 14 September 2017, 3:14 am EST

  With the FlexGrid it is possible for the end-user to sort each column either ascending or descending. It is also possible for them to filter the results based on values in each column.

  Is it possible to programmatically see these changes that the user has made to the grid they are viewing. Is it also possible to programmatically apply such sorting / filtering to the grid? Our idea is to allow the user to save their viewing preferences so that the next time they load the grid it is already sorted and filtered as they wish.

  I can see the columnLayout property, which could be used to get/set the ordering of columns but not the above information

• 

  manish-gupta1

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 3:14 am EST

  Hi,
  
  There is sortingColumn event in FlexGrid which can be used to find out if sorting is done by column header click. Same you can get filter applied or not through filterApplied event of FlexGridFilter class.
  
  You can retrieve current sorting and filtering for FlexGrid using sortDescriptions of CollectionView and filterDefinition property of FlexGridFilter class and store in localStorage and assigned back whenever required.

  Thanks,
  
  Manish Kumar Gupta

• 

  stuart-palmer

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 3:14 am EST

  Thanks Manish, that’s very helpful