Skip to main content
2 of 2
fixed spelling mistake
Milind
  • 1.5k
  • 17
  • 43

SharePoint 2013 Rest API OData Query

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.

Milind
  • 1.5k
  • 17
  • 43