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