Searching server side

Question

Hi support, i've a grid with the server side searching field in the toolbar. I've implemented the server side controller with webapi adaptor (<EjsDataManager Url="https:xxxxxx" Adaptor="Adaptors.WebApiAdaptor"></EjsDataManager>.

When i search data the $filter querystring variable is correctly filled but the value contains the OData syntax (substringof('value', filedname)).

Why if i use a webapi and not odata adaptor, the syntax is non contains() ?

Thanks in advance

Stefano

Renjith Singh Rajendran · Answer

Hi Stefano, 

Thanks for contacting Syncfusion support. 

As explained in the below documentation, EjsDataManager’s WebApiAdaptor is derived from ODataAdaptor. So we will be using the OData standards to process the WebApi service requests. You can handle the search operation in Grid based on the Request.Query you get from the WebApi service requests.  

In the querystring, you will get all the details needed to process a search action in Grid. With those details you can handle the search operation in your WebApi service. 
Documentation : https://ej2.syncfusion.com/blazor/documentation/grid/data-binding/#web-api 

Please get back to us if you need further assistance. 

Regards, 
Renjith Singh Rajendran.