Date Filter in Excel Like filter is not working as expected

Question

Hi Team,I am trying to add excel-like filters in the grid for date filtering. When I  open up the filter dialog, it doesn't show all the dates available. But if I filter it using between date option in date filter, even though it filters the date in the grid but still doesn't show in the filter dialog. I want to show the available dates as checkbox options for the user to select.https://stackblitz.com/edit/angular-syncfusiongrid-date-filter-v31jav?file=src/app/app.component.tsThanks

Manivel Sellamuthu · Answer

Hi Darryl, 

Greetings from Syncfusion support. 

By default while using checkbox filter, it will query 1000 data only, due to large data transfer may leads to  serialization issue and performance downgrade. After that from the fetched records, we will get the distinct value and display the checkbox items. From the shared  sample we could see that for the first 100 records there is no other different dates than 30/04/2020  and null.  

So to achieve your requirement we can increase the filter count as like the below code example. 





public actionBegin(args) { 
        if (args.requestType == "filterchoicerequest") { 
            args.filterChoiceCount = 3000;                      //here, you can override the default take count of the filter records 
        } 
    } 
 
Modified sample: https://stackblitz.com/edit/angular-syncfusiongrid-date-filter-prp4vj?file=src%2Fapp%2Fapp.component.ts 
 
Please get back to us, If you need further assistance. 

Regards, 
Manivel