Query#1: This is bcz you guys doing query for 1st 1000
records so that iam facing this issue.I have override your query through
actoinbegin e
Yes, By default, the Excel/ Checkbox filter Dialog in the
Grid will display the distinct data from the first 1000 records in grid
dataSource to optimize the performance. You can increase the Excel filter
choice count by modifying the filterChoiceCount argument value in the actionBegin
event when the requestType is ‘filterchoicerequest’ as
demonstrated in the below code snippet,
|
actionBegin(args){
if(args.requestType == 'filterchoicerequest'){
args.filterChoiceCount = 5000; // change the filterchoicecount value as you need (the filter check list shown based
on this value )
}
}
|
If you are facing any issues with this solution in your
angular application, please get back to us with more details, like Grid code example, Syncfusion package version, Screenshot of the issue, and a simple replication
example which will be helpful for us to provide a better solution.
Query#2: Excel Filter Not Working With Blank Rows
Before validating the query, please share the below details which
will be helpful for us to provide a better solution as early as possible.
- Share
the Grid sample
- In
which type of column (like string, number, date, boolean) you are facing
the blank value filtering issue
- Share
the Syncfusion package version
- “From
the “data” tab select the “Filter” option.” – Share the UI for this
scenario
