Example : all customers from Berlin, Germany http://host/service/Customers? $filter=concat(concat(City,', '), Country) eq 'Berlin, Germany' contains The contains function has the following signature: Edm.Boolean contains(Edm.String,Edm.String) The contains function returns true if the second parameter string is a substring of the first parameter string value, otherwise it returns false. The containsMethodCallExpr syntax rule defines how the contains function is invoked. Example : all customers with a CompanyName that contains 'Alfreds' http://host/service/Customers?$filter=contains(CompanyName,'Alfreds') endswith The endswith function has the following signature: Edm.Boolean endswith(Edm.String,Edm.String) The endswith function returns true if the parameter string value ends with the second parameter string value, otherwise it returns false. The endsWithMethodCallExpr syntax rule defines how the endswith function is invoked. Example : all customers with a CompanyName that ends with 'Futterkiste' http://host/service/Customers?$filter=endswith(CompanyName,'Futterkiste') indexof The indexof function has the following signature: Edm.Int32 indexof(Edm.String,Edm.String) The indexof function returns the zero-based character position of the first occurrence of the second parameter value in the first parameter value, or -1 if the second parameter value does not occur in the first parameter value. The indexOfMethodCallExpr syntax rule defines how the indexof function is invoked. Example : all customers with a CompanyName containing 'lfreds' starting at the second character http://host/service/Customers?$filter=indexof(CompanyName,'lfreds') eq 1 length The length function has the following signature: length(Edm.String) The length function returns the number of characters in the parameter value. The lengthMethodCallExpr syntax rule defines how the length function is invoked. Example : all customers with a CompanyName that is 19 characters long http://host/service/Customers?$filter=length(CompanyName) eq 19 startswith The startswith function has the following signature:
Example : all customers from Berlin, Germany http://host/service/Customers? $filter=concat(concat(City,', '), Country) eq 'Berlin, Germany' contains The contains function has the following signature: Edm.Boolean contains(Edm.String,Edm.String) The contains function returns true if the second parameter string is a substring of the first parameter string value, otherwise it returns false. The containsMethodCallExpr syntax rule defines how the contains function is invoked. Example : all customers with a CompanyName that contains 'Alfreds' http://host/service/Customers?$filter=contains(CompanyName,'Alfreds') endswith The endswith function has the following signature: Edm.Boolean endswith(Edm.String,Edm.String) The endswith function returns true if the parameter string value ends with the second parameter string value, otherwise it returns false. The endsWithMethodCallExpr syntax rule defines how the endswith function is invoked. Example : all customers with a CompanyName that ends with 'Futterkiste' http://host/service/Customers?$filter=endswith(CompanyName,'Futterkiste') indexof The indexof function has the following signature: Edm.Int32 indexof(Edm.String,Edm.String) The indexof function returns the zero-based character position of the first occurrence of the second parameter value in the first parameter value, or -1 if the second parameter value does not occur in the first parameter value. The indexOfMethodCallExpr syntax rule defines how the indexof function is invoked. Example : all customers with a CompanyName containing 'lfreds' starting at the second character http://host/service/Customers?$filter=indexof(CompanyName,'lfreds') eq 1 length The length function has the following signature: length(Edm.String) The length function returns the number of characters in the parameter value. The lengthMethodCallExpr syntax rule defines how the length function is invoked. Example : all customers with a CompanyName that is 19 characters long http://host/service/Customers?$filter=length(CompanyName) eq 19 startswith The startswith function has the following signature:
odata-v4.01-wd02-part2-url-conventions-2017-03-24.docx