In this article we can explore OData using Numeric Comparison filters.
Numeric Comparison Filters
Following are the Numeric Comparison filters available with OData
|le||Less Than or Equals To|
|ge||Greater Than or Equals To|
|ne||Not Equal To|
To proceed with the example I encourage you to create a Contacts list with a column named Age of type integer. Please fill some data appropriately.
Following is the example of using Equal filter where the column Age is equal to 30.
The result was one list item as per my data.
Please note that uppercase (EQ) won’t work.
Following is the example of using Not Equal filter where the column Age is not equal to 30.
Obviously it returned a lot of items.
Following is the example of using Less Than filter.
As there are no items with Age less than 10, my result was empty.
Similarly you can play with the remaining Arithmetic operators.
In this article we have explored Numeric Comparison filters of OData on SharePoint 2013 REST services.