We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to return unique values from server end for excel filter checkbox ?

Platform: ASP.NET Core |
Control: Grid |
Published Date: September 12, 2018 |
Last Revised Date: September 12, 2018

This knowledge base explains how to return unique values from the server end for excel filter checkbox values.

Solution:

By default, if we bind more than 1000 records in Grid then the excel filter will show only distinct values from the first 1000 records of Grid dataSource. If we have one distinct value from the first 1000 records, then it will return only one distinct value from server end.

To overcome this, we need to return the 1000 (default value of MaximunFilterChoice) distinct values of entire Grid dataSource from the server, by passing the filtering column name to server end through the actionBegin event of ejGrid and based on that we can get the distinct values from server end.

  1. The Grid initialization as follows.

HTML

 

JS

 

MVC

 

 

 

ASP

 

 

 

CORE

 

 

 

Angular

 

TS

 

  1. In the Client side actionBegin event we can get the filtering column name and we set it to the select query of Grid.

 

 

Result:

Figure 1: Shown some unique values in excel filter dialog for CustomerID column in Grid.

2X faster development

The ultimate ASP.NET Core UI toolkit to boost your development speed.
ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile