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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to achieve searching in grid with WCF/OData service?

This KB showcase the example to achieve the searching operation in grid when WCF/Odata service is used.

Solution

In WCF/Odata service, we don’t have the default searching support. So, to achieve the searching in remote data use customAdaptor to modify the default search query string.

Step 1: Render the Grid control

HTML

JS

MVC

 

ASP

 

.Net core

 

Angular

 

TS

 

Step 2: Modify the search query in the customAdaptor function

 

 

Step 3:  Extend the OData adaptor as custom adaptor in grid load event.

 

Refer the below link for JS-playground sample

http://jsplayground.syncfusion.com/jb1j4q2w

Also refer the below link for custom adaptor script file. 

http://www.syncfusion.com/downloads/support/directtrac/general/ze/customadaptor-1287990129.zip  

 

Note: Please refer the custom Adaptor script file after the ej.web.all.min.js file. 

 

 

Figure: Remote data Query string.

Article ID: Published Date: Last Revised Date: Platform: Control:
9045 07/30/2018 07/30/2018 JavaScript ejGrid
Did you find this information helpful?
Add Comment
You must log in to leave a comment

Please sign in to access our KB

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

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