Can't make Excel-like Filtering Hierarchical Data in wijmo Grid(Angular)

Can't make Excel-like Filtering Hierarchical Data in wijmo Grid(Angular)

Posted by: shoham.yamin on 16 August 2020, 7:34 am EST

• 

  shoham.yamin

  • Post Options:
  • Link
    Copy

  Posted 16 August 2020, 7:34 am EST - Updated 3 October 2022, 11:40 pm EST

  I’m trying to make a filter “Excel-like Filtering” for Hierarchical Data wijmo Grid(Angular).
  
  The filter shows only the fields of the raws of the high level of the Hierarchy, so I have a problem when I need to filter data and fields from the low level of the Hierarchy. I saw the sample for search with Hierarchical Data, but I need something like the Excel-like Filtering. there is a way to make something like this with some configuration of the component
  
  I add an image for example when I try to filter Type by “NRE” he doesn’t show this value in the options of the filtering

  

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 18 August 2020, 12:53 am EST

  Hi Shoham,

  FlexGridFilter is not compatible with hierarchical data. The filtering is performed using CollectionView, which only works with flat arrays. Displaying the data as a tree is only a feature of FlexGrid and not of CollectionView. So, you cannot add an excel like filter with tree grid.

  We are sorry for inconvenience.

  Regards,
  
  Ashwin