Resource Filtering

Filtering can be done on the following resources

CardFile, Document, Job, Contract, Purchase, Quote, Stock

Filtering is done using the following operators:

DescriptionOperator
Greater than or equal[-gte]
Less than or equal[-lte]
Not equal[-ne]
Less than[-lt]
Greater than[-gt]
Equal[-eq]
Like (contains)[-like]

Filter field types

IntA numberDoes not support Like opeator
BoolBoolean expressed as, True or False, Y or NSupports Equal & Not equal operators
TextCase in-sensitive textSupports Equal, Not equal and Like operators
DateDateTime in ISO formatDoes not support Like opeator

Filtering format

Filters can be combined using AND (&). Note OR filters are not yet supported.
Filter Format = filter[Field][Operator]value

Example: ?filter[Name][-eq]John&filter[Age][-gt]40&filter[Married][-eq]T&filter[Born][-gt]2010-01-01T00:00:00