We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Filters not showing every values


I am facing this issue when filtering on a grid.

Let's say I have columns column1 and column2.

I filter for 'xyz' on column2.

On column1 I now have two distinct values 'aaa' and 'bbb', but when I try to filter on column1 there is no option 'bbb':

I just discovered this, could you kindly check if you can reproduce it?

These are the syncfusion dependencies versions I'm using for this project:

    "@syncfusion/ej2-react-buttons": "^20.1.47",
    "@syncfusion/ej2-react-dropdowns": "^20.1.50",
    "@syncfusion/ej2-react-grids": "^20.1.48",
    "@syncfusion/ej2-react-inputs": "^20.1.48",
    "@syncfusion/ej2-react-lists": "^20.1.47",
    "@syncfusion/ej2-react-popups": "^20.1.47",

The grid contains around 1800 rows, around 10 have column2 equal to xyz, of which 7 have column1 equal to aaa and 3 to bbb.
Column2 has 10 distint values (3 of which have 500 entries, the other are 10-100)
Column1 has 60 distint values (most have less than 20 entries, 3 has around 100-300)

Thank you in advance,
Matteo Messmer

2 Replies 1 reply marked as answer

MA matteomessmer December 2, 2022 01:45 PM UTC

Solved with https://ej2.syncfusion.com/react/documentation/grid/filtering/excel-like-filter/

  public actionBegin(args: FilterSearchBeginEventArgs) {
        if (args.requestType === "filterchoicerequest" || args.requestType === "filtersearchbegin") {
            args.filterChoiceCount = this.props.documents.length;

where this.props.documents.length is the number of rows in the grid.


Marked as answer

SG Suganya Gopinath Syncfusion Team December 5, 2022 04:56 AM UTC

Hi Matteomessmer,

We are glad that the issue has been resolved. Please get back to us for further assistance.

We are marking this ticket as solved.


Suganya Gopinath.

Live Chat Icon For mobile
Up arrow icon