Search Filters

Filters

It is required to always specify the filter type for the filters. Supported filter types are listed below. Others types are not supported.

eq 
{ "status" : { "eq" : 1 } }
The "Equals" filter.
neq 
{ "sku" : { "neq" : "product1" } }
The "Not Equals" filter.
gt 
{ "order_id" : { "gt" : 5 } }
The "Greater Than" filter.
lt 
{ "order_id" : { "lt" : 5 } }
The "Less Than" filter.
gteq 
{ "order_id" : { "gteq" : 5 } }
The "Greater Than or Equals" filter.
lteq 
{ "order_id" : { "lteq" : 5 } }
The "Less Than or Equals" filter.
from 
{ "created_at" : { "from" : "2014-07-12 14:12:47", "datetime" : true } }
{ "created_at" : { "from" : "2014-07-12" } }
The "From" date filter.
to 
{ "created_at" : { "to" : "2014-07-12 14:12:47", "datetime" : true } }
{ "created_at" : { "to" : "2014-07-12" } }
The "To" date filter.
in 
{ "order_id" : { "in" : [ 114, 115 ] } }
The "In" filter.
nin 
{ "order_id" : { "nin" : [ 114, 115 ] } }
The "Not In" filter.
null 
{ "target_ship_date" : { "null" : 1 } }
The "NULL" filter.
notnull 
{ "target_ship_date" : { "notnull" : 1 } }
The "Not NULL" filter.