Typing Multiple Values In ag-grid Floating Filter

Question

See plunker: https://plnkr.co/edit/JEJ4j3ANQe4ZCnXI

Pressing buttons 'Age Between 25 and 30' or 'Ireland & UK' filters the grid for multiple values.

For example, pressing button 'Age Between 25 and 30' i can see in the header filter text:

25-30

Is applied yet if i try to type this manually, it does not work.

Same for Sports column, i would have expected:

Rowing OR Fencing

to filter the grid to just the above 2 sports but again, doesnt work.

Update:

To replicate issue:

Open link above
Scroll right to display Sport column
Type the following: 'Rowing OR Fencing'

Grid is now empty.

You need to be more specific. Both examples of problems work fine. For the 25-30 filter, you realise you need to use the in range filter type right? — ViqMontana

Pratik Bhat Pratik Bhat · Accepted Answer · 2020-07-20T23:20:20

As per docs -

The floating filters for Text, Number and Date (the simple filters) are editable when the filter has one condition and one value. If the floating filter has a) two conditions or b) zero (custom option) or two ('In Range') values, the floating filter is read-only.

What this means is when you use floating filter to filter on column it will filter on one value only. If you want to add more than one filtering condition you will have to use the filter button that shows up a filtering menu.

Here is how your 'Rowing OR Fencing' is interpreted when entered in floating filter.

The correct way would be to open the filter menu and add multiple filter criteria instead of typing in floating filter. In this case floating filter becomes read only.

Typing Multiple Values In ag-grid Floating Filter

1 Answers