Including standard functions in search criteria

object edited this page Oct 9, 2012 · 8 revisions

OData protocol supports standard functions that can be included in search criteria.


Find a product with the given name coverted to a lowercase format

var product = _db.Products.Find(_db.Products.ProductName.ToLower() == "chai");
Assert.Equal("Chai", product.ProductName);

Request URI: GET Products?$filter=tolower(ProductName)+eq+%27chai%27


Find a product with the length of name equal to 4

var product = _db.Products.Find(_db.Products.ProductName.Length() == 4);
Assert.NotEmpty(products);

Request URI: GET Products?$filter=length(ProductName)+eq+4


Find a product with the name starting with the given string

var product = _db.Products.Find(_db.Products.ProductName.StartsWith("Ch") == true);
Assert.NotEmpty(products);

Request URI: GET Products?$filter=startswith(ProductName%2c%27Ch%27)+eq+true


Find a product with the name containing the given string

var product = _db.Products.Find(_db.Products.ProductName.Contains("ai") == true);
Assert.NotEmpty(products);

Request URI: GET Products?$filter=substringof(%27ai%27%2cProductName)+eq+true


Find a product with the name not containing the given string

var product = _db.Products.Find(_db.Products.ProductName.Contains("ai") == false);
Assert.NotEmpty(products);

Request URI: GET Products?$filter=substringof(%27ai%27%2cProductName)+eq+false


Find a product with the name containing the given string at the specified position

var product = _db.Products.Find(_db.Products.ProductName.IndexOf("ai") == 2);
Assert.NotEmpty(products);

Request URI: GET Products?$filter=indexof(ProductName%2c%27ai%27)+eq+2


Alternative syntax for finding a product with the name containing the given string at the specified position

var product = _db.Products.Find(_db.Products.ProductName.Substring(1) == "hai");
Assert.NotEmpty(products);

Request URI: GET Products?$filter=substring(ProductName%2c1)+eq+%27hai%27


See also:
Retrieving data
OData URI conventions