Collection of field names, conditions, and values used to filter the query
List of field names accepted:
createdAt
(gt, ge, lt, le, eq, ne)
lastModified
(gt, ge, lt, le, eq, ne)
startDate
(gt, ge, lt, le, eq, ne)
dbaname
(ct, nct)
status
(eq, ne)
legalname
(ct, nct)
externalPaypointID
(ct, nct)
ein
(ct, nct)
address
(ct, nct)
city
(ct, nct)
state
(ct, nct)
phone
(ct, nct)
mcc
(ct, nct)
owntype
(ct, nct)
ownerName
(ct, nct)
contactName
(ct, nct)
paypointId
(eq, ne)
orgParentname
(ct, nct, in, nin)
boardingId
(eq, ne)
entryName
(ct, nct)
externalOrgID
(ct, nct)
List of comparison accepted - enclosed between parentheses:
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
nin
=> not inside array
List of parameters accepted:
limitRecord
: max number of records for query (default=“20”, “0” or negative value for all)
fromRecord
: initial record in query
Example: dbaname(ct)=hoa
return all records with dbname containing “hoa”