Filter values

Question

Hello,So I faced an issue with checkbox filter values. Where I take only 1000 rows to not to crash on filter data load, but if the unique value is above 1000~ it won't be taken. Grid contains 100k~ items and i can't just take all and get the unique values, it must be approached in some other way. So I thought about my own view that sets data for the checkbox filter and I wanna ask if somehow I can apply that data to checkbox by my own. Or maybe you can suggest something else that helps to solve this problem.

Venkatesh Ayothi Raman · Answer

Hi Domantas, 

Thanks for contacting Syncfusion support. 

Query: but if the unique value is above 1000~ it won't be taken 

In Grid excel filter by default take filter records from server is 1000 records as well as it works like a load on demand concept. So, if we want to filter 1001 record , then we can search the value in excel filter search box and it returned the result. Please refer to the following screenshot, 

  

For your requirement, we have overridden the default take as mentioned in the below code example. So the default take value for the filtered records can be increased or decreased using filterChoiceCount property as per the requirement. Please refer to the below code example for your reference. 

Code example: 





... 
actionBegin(args:any) { 
        if (args.requestType == "filterchoicerequest") { 
            args.filterChoiceCount = 1200;                      //here, you can override the default take count of the filter records 
        } 
    } 
... 

Please get back to us for further assistance. 

Regards, 
Venkatesh Ayothiraman.