1. Home
  2. Forum
  3. jQuery
  4. Using excel filter events you can change the dataSource of the checkbox list.

Using excel filter events you can change the dataSource of the checkbox list.

Hi,

We wanted to buy the Syncfusion for our application needs. 

In order to do that, we wanted to make sure the below requirement is possible with ejGrid. 

We wanted to load only 1 page of data i.e 10 records to get the data displayed very quick on the Grid because there are half million data to load. 

But when we use excel filtering, how can we get filter operations on entire data set. In other words how can we customize the checkbox list of excel filtering.

Can you please provide me the example code that shows this and how the grid refreshes upon filtering. 

I have put subject line same as what mentioned in the below post but it did not show us how to do that.


Thanks


2 Replies
MP Manivannan Padmanaban Syncfusion Team May 18, 2020 11:45 AM UTC

Hi Rama, 

Greetings from Syncfusion Support. 

From the shared query, we are able to understand that you want to use on demand paging along with entire data set filtering.  

By default we can load the desire record into grid by using UrlAdaptor with paging. Request query will be sent to server for that paging to handle the skip and take based on pageSettings.  
Like that, if we open the Excel filter dialog a request query will be sent to the server and the checkbox list was created from distinct values of the dataSource filter column. 

Also in the generation of checkbox lists, if the number of distinct values is greater than 1000, then the excel filter displays only the first 1000 values and displays the label "Not all items shown"  
to ensure the best performance in rendering and searching. However this limit has been customized according to your requirement by setting filterSettings.maxFilterChoices with required limit in integer. 

Please get back to us, if you need further assistance. We will be happy to assist you. 

Regards, 
Manivannan Padmanaban 


MP Manivannan Padmanaban Syncfusion Team May 18, 2020 11:49 AM UTC

Hi Rama, 

We also would like to let you know about our next generation JavaScript product - Essential JS 2, in case if you are not aware of it. Essential JS 2 is fully re-written to be modular, responsive and lightweight.  
   
We suggest you consider our following product page for more details.  
   
Demo page for ej2 Grid  

Regards, 
Manivannan Padmanaban. 


Loader.
Up arrow icon