Column Menu Filtering item is not listing all the options on the Data Grid Table

[GUU]

Hi, I am using a hierarchy data grid model. 

Filtering the table data through 'Column Menu Filter item', the filter drop down is not listing all the options, even though column data was already loaded on the table. 

In the example shown in the image, the 'Not Allocated' is already on the table but doesn't exist in the filtered column. Only when we search does it appear in the list. Is there a way to show the missing value 'Not Allocated' in the list?

[Jayshankar Manoharan]

Hi GUU,

Greetings from Syncfusion Support,

Query - Filtering the table data through 'Column Menu Filter item', the filter drop down is not listing all the options, even though column data was already loaded on the table. 

By default, the excel/checkbox filter in the Grid will display the data from the first 1000 records to optimize performance. The other records will be returned as result in the search option of the Filter dialog. 

We suspect that the data that you have mentioned as not displayed in the filter dialog might be stored after 1000 records and that is the reason it is not displayed.

You can increase the excel/checkbox filter count by modifying the filterChoiceCount argument value in the actionBegin event when the requestType is ‘filterchoicerequest’.

For your convenience, we have attached code sample for your reference.

[index.js]

 

// Grid’s actionBegin event function

function onActionBegin(args) {

        if (args.requestType === "filterchoicerequest") {‘

            // modify the count as you want

            args.filterChoiceCount = 3500;

        }

}

Please get back to us if you need further assistance on this.

Regards,

Jayshankar Manoharan