SharePoint 2013 Rest API OData Query

Question

I am calling rest uri from jQuery ajax with filter string comparison startswith as below

/_api/lists/getbytitle('Stations')/items?$select=Id,City_Code,City_Name_EN&$filter=startswith(City_Name_EN,'M') and Active eq 1&$orderby=City_Name_EN asc

Which is working very good. And I am displaying text by programmatically as below

Mumbai(Mum) i.e. City_Name_EN (City_Code)

but is there anyway to filter startwith(City_Name_EN (City_Code),'M') .

I tried to make calculated field in above format. But rest api does not allow to filter calculated field.

Is there any way to filter like that.

Answer 1

It's not clear exactly what you want to do, but OData $filter has a startswith that you should be able to use here.

$filter=startswith(City_Name_EN,'M')

See this page: http://msdn.microsoft.com/en-us/library/ff798339.aspx and do a find for "startswith".

When in doubt, check the OData spec. SharePoint implements it for the most part, though there are exceptions, e.g., batching.