Collection of field names, conditions, and values used to filter the query.
See Filters and Conditions Reference for more details.
List of Accepted Field Names:
createdDate
(gt, ge, lt, le, eq, ne)
customernumber
(ne, eq, ct, nct)
firstname
(ne, eq, ct, nct)
lastname
(ne, eq, ct, nct)
name
(ct, nct)
address
(ne, eq, ct, nct)
city
(ne, eq, ct, nct)
country
(ne, eq, ct, nct)
zip
(ne, eq, ct, nct)
state
(ne, eq, ct, nct)
shippingaddress
(ne, eq, ct, nct)
shippingcity
(ne, eq, ct, nct)
shippingcountry
(ne, eq, ct, nct)
shippingzip
(ne, eq, ct, nct)
shippingstate
(ne, eq, ct, nct)
phone
(ne, eq, ct, nct)
email
(ne, eq, ct, nct)
company
(ne, eq, ct, nct)
username
(ne, eq, ct, nct)
balance
(gt, ge, lt, le, eq, ne)
status
(in, nin, eq, ne)
additional-xxx
(ne, eq, ct, nct) where xxx is the additional field name
orgId
(eq) mandatory when entry=org
paypointId
(ne, eq)
paypointLegal
(ne, eq, ct, nct)
paypointDba
(ne, eq, ct, nct)
orgName
(ne, eq, ct, nct)
List of Accepted Comparisons:
eq
or empty => equal
gt
=> greater than
ge
=> greater or equal
lt
=> less than
le
=> less or equal
ne
=> not equal
ct
=> contains
nct
=> not contains
in
=> inside array separated by ”|”
nin
=> not inside array separated by ”|”
Accepted Parameters:
limitRecord
: Max number of records for query (default=“20”, “0” or negative value for all)
fromRecord
: Initial record in query
Example Usage:
balance(gt)=20
will return all records with a balance greater than 20.00.