Filter list does not show all values

[eric]

We have a grid with ~5,000 rows using the excel filter that should show 3 values in the filter list. Instead it shows 2 out of the 3 as seen here:

When I start entering the missing 3rd value it appears as shown here:

Can I control this behaviour so the third choice always appears?

[Pavithra Subramaniyam]

Hi eric,

Greetings from Syncfusion.

By default, while opening the Excel/checkbox filter in the Grid, the filter dialog will get and display only the distinct data from the first 1000 records bound to the Grid to optimize performance. The remaining records will be returned as a result in the search option of the Filter dialog. This is the default behavior of this functionality.

We suspect that in your case, the 1^st 1000 records only have the 2 values, so we suggest you increase the filter count by modifying the filterChoiceCount argument value in the actionBegin event when the requestType is ‘filterchoicerequest’ as demonstrated in the below code snippet,

 

<ejs-grid #grid [dataSource]="data" allowFiltering="true" [filterSettings]="filterSettings"

  (actionBegin)="actionBegin($event)">

.  .  .

</ejs-grid>

 

 

actionBegin(args) {

  if ( args.requestType == 'filterchoicerequest' || args.requestType == 'filtersearchbegin') {

    args.filterChoiceCount = 5000;

  }

};

 

 

https://ej2.syncfusion.com/angular/documentation/api/grid/#actionbegin

Regards,

Pavithra S

[eric]

that works perfectly. thank you.

[Suganya Gopinath]

We are glad that the provided solution helped to solve the issue. Please get back to us for further assistance.