Filter on multiple columns

Suite and Optimus Suite 5
#1

I applied text filters on two columns, these work well separately. But when I try to combine the filter, it does not give expected result.

Refer below screenshots for explanation:

  1. Tree grid is loaded.
  2. I filter on 3rd column, it gives the expected result.
  3. I expand one of the rows. Works fine.
  4. Now, when I try to apply the filter on 1st column, it does not show anything. I tried to debug this and found that while filtering on column 1, it does not take into consideration the rows that got loaded on expanding the parent row after filtering.

Please help in this respect. Thanks.

1.png1080×270 5.17 KB


2.png1039×239 4.92 KB


3.png1039×361 7.05 KB

#2

Attached screen 4

4.png1045×204 2.54 KB

#3

All header-filters has OR logic of filtration.
There is no way to use several filters with OR logic between them.

You will have to create your own custom filter.
Here is the tutorial:
docs.dhtmlx.com/doku.php?id=dhtm … any_values

#4

I am good even if it does not combine the two filters.
The problem here is, filter on column 1 does not identify the rows which were loaded after filtering column 3.

When i type a value in filter 1 (filter on column 1), it compares it only with the rows in green, and not with those in red. :cry:

Just help me find a way where the filter recognizes the rows in red.

5.png879×282 6.57 KB

#5

Please, try to use the setFiltrationLevel() method:
docs.dhtmlx.com/doku.php?id=dhtm … ationlevel