Filters not showing every values

[matteomessmer]

Hi,

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

[matteomessmer]

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.

Sorry

[Suganya Gopinath]

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.

Regards,

Suganya Gopinath.