Collection of field names, conditions, and values used to filter the query
See Filters and Conditions Reference for help.
List of field names accepted:
- categories (ct, nct)
- code (ne, eq, ct, nct)
- commodityCode (ne, eq, ct, nct)
- createdDate (gt, ge, lt, le, eq, ne)
- description (ne, eq, ct, nct)
- externalPaypointID (ct, nct, ne, eq)
- mode (eq, ne)
- name (ne, eq, ct, nct)
- orgName (ne, eq, ct, nct)
- paypointDba (ne, eq, ct, nct)
- paypointId (ne, eq)
- paypointLegal (ne, eq, ct, nct)
- quantity (gt, ge, lt, le, eq, ne)
- uom (ne, eq, ct, nct)
- updatedDate (gt, ge, lt, le, eq, ne)
- value (gt, ge, lt, le, eq, ne)
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 separated by ”|”
- nin => not inside array separated by ”|”
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: name(ct)=john return all records with name containing john