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 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

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.