FlexGrid column filtering / sorting

Originally Posted 4 September 2017, 11:36 am EST

  • Originally Posted 4 September 2017, 11:36 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
  • Reply

    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
  • Marked as Answer

    Reply

    Thanks Manish, that's very helpful
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels