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.
Unfortunately, activation email could not send to your email. Please try again.

How to perform searching in whole datasource of the Grid?

By default, the grid searches for the key value only in the columns defined in the Grid column definition. In some cases, we may like to search whole dataSource for the search Key.

Solution:

We can achieve the above requirement by adding all the field names to the searchSettings.fields property of the Grid.

Example:

In the following example, we have rendered a grid with searching enabled.

  1. Render the grid

JS:

 

MVC

 

ASP

 

  1. In the DataBound event of the Grid, we can get the first JSON array of the dataSource. By traversing through this, we can get all the field names in the dataSource which we add to the serachSettings.fields property of the Grid

 

 

JS Playground link: http://jsplayground.syncfusion.com/amdr43qc

Result:

Fig 1: Initial Rendering

 

Fig 2: On Searching operation

 

Article ID: Published Date: Last Revised Date: Platform: Control:
6301 02/15/2016 02/15/2016 JavaScript ejGrid
Did you find this information helpful?
Add Comment
You must log in to leave a comment

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.