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.