I tried Remote Filtering and it sends Filter="startswith(JobExecutionStatus,'fai') eq true and Name eq 'file merge job'" (In OData Format)
But I is there any way I can get simple format like (Field = 'value' or Field > 5) ?
I need this because I am not using Linq I am calling a webservice instead from my controller which needs filter in simple format
Hi,
I have implemented remote filtering and sorting. After sort If I apply filter it does not work because it send requests like this -
?%24orderby=name+asc&filter(name)=contains(21)&%24skip=0&%24top=10&%24inlinecount=allpages&pk=id&_=1419248474621
Its very difficult to expand values from parameters because user can apply more than five filters and in request for filter parameter we get like "filter(voice_number)=contains(58)" for each of the applied filters respective to column and values typed.
Same situation when applying more than one filter, like this -
?filter(name)=contains(fact)&filter(voice_number)=contains(58)&%24skip=0&%24top=10&%24inlinecount=allpages&pk=id&_=1419249386184
I want the previous filter to get clear from request and the current selected filter should be sent with the request.
Any help appreciated.
Thanks.
you can refer to the following topic:
http://help.infragistics.com/Help/Doc/jQuery/2011.2/CLR4.0/HTML/igGrid_Filtering.html
basically you can change the following option, in order to customize the way the URL is parameters are constructed - filterExprUrlKey . Other than that you can consume the request in different ways on the server. If you have a WCF service you would get this key from the request and parse the value. Here is an example of a filtering request which filters by two columns at the same time, and has customized filterExprUrlKey:
samples.infragistics.com/.../GridGetData
Hope it helps. Thanks,
Angel