Grouping and Filtering

Grouping and Filtering

Posted by: echambon on 1 October 2019, 6:51 am EST

• 

  echambon

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 1 October 2019, 6:51 am EST

  Hi,

  It looks like filtering causes issues with the grouping.
  
  I am taking the AnalyzeNew example (in v4.5.2\C1FlexGrid) that you provided, and have just added the filtering on the first table (_flexDataTable.AllowFiltering = true;).

  If I filter on the productName, first of all, I am surprised some empty groups still get displayed.
  
  Then I update one visible cell (the order date of an existing row for instance). Once I press enter, the whole grid changes and is now showing unexpected cells.
  
  If I then remove the filter, I can see cells that are not inside any grouping, whereas I was expecting to get back to the initial records. The grid is completely wrong.

  If I update one cell again, then the whole grid is back to normal.

  I have enclosed an example. Can you please have a look ?

  Thanks

  AnalyzeNew.zip

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 3 October 2019, 5:15 am EST

  Hello,

  When filtering is applied on the Grid it changes the rows’ visibility depending upon the condition so it could be possible that some empty groups still get displayed.

  To display the correct grouping as per the applied filtering, you need to set the grouping again that is currently applied on the Grid in the AfterFilter event of FlexGrid.

  I have modified the last attached sample , please have a look

  Regards,
  
  Prabhat Sharma.
  
  AnalyzeNew1.zip

• 

  echambon

  • Post Options:
  • Link
    Copy

  Posted 3 October 2019, 5:41 am EST

  That solved this issue, thank you very much.