Comparators

Depending on the columns data type different comparators can be used with the ColumnFilter attribute in the request. Each response from a GET request contains a property called columns that specifies each columns data type.

SOAPREST

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
  <soapenv:Header/>
  <soapenv:Body>
    <GetItemsResponse requestedPage="4" page="4" pageSize="100" totalNumberOfPages="10" totalNumberOfItems="1000" xmlns="http://www.easit.com/bps/schemas">
      <Columns>
        <Column datatype="INTEGER" collection="false">Id</Column>
        <Column datatype="DATETIME" collection="false">Created</Column>
        <Column datatype="CONNECTION" collection="false" connectiontype="PROPERTY">Status</Column>
      </Columns>
      <Items>
        <Item id="138:2">
          <Property name="Id" rawValue="201">201</Property>
          <Property name="Created" rawValue="2020-03-16T14:30:08.000Z">2020-03-16 15:30</Property>
          <Property name="Status" rawValue="74:1">Open</Property>
        </Item>
      </Items>
    </GetItemsResponse>
  </soapenv:Body>
</soapenv:Envelope>

{
  "columns":{
    "column": [
      {
        "content": "Id",
        "datatype": "INTEGER",
        "collection": false,
        "connectiontype": null
      },
      {
        "content": "Created",
        "datatype": "DATETIME",
        "collection": false,
        "connectiontype": null
      },
      {
        "content": "Status",
        "datatype": "CONNECTION",
        "collection": false,
        "connectiontype": "PROPERTY"
      }
    ]
  },
  "items": {
    "item":[
      {
        "property": [
          {
            "content": "201",
            "name": "Id",
            "rawValue": "201"
          },
          {
            "content": "2020-03-16 15:30",
            "name": "Created",
            "rawValue": "2020-03-16T14:30:08.000Z"
          },
          {
            "content": "Open",
            "name": "Status",
            "rawValue": "74:1"
          }
        ],
        "attachment": [],
        "id": "138:2"
      }
    ]
  },
  "requestedPage": 4,
  "page": 4,
  "pageSize" : 100,
  "totalNumberOfPages": 10,
  "totalNumberOfItems": 1000,
}

Comparator matrix

Here you can see what comparator you can use with each data type.

Comparator	Data type
EQUALS	STRING, TEXT, INTEGER, DECIMAL, FLOAT, BOOLEAN
NOT_EQUALS	STRING, TEXT, INTEGER, DECIMAL, FLOAT, BOOLEAN
LIKE	STRING, TEXT
NOT_LIKE	STRING, TEXT
IN	CONNECTION
NOT_IN	CONNECTION
GREATER_THAN	INTEGER, DECIMAL, FLOAT, DATE, DATETIME
GREATER_THAN_OR_EQUALS	INTEGER, DECIMAL, FLOAT, DATE, DATETIME
LESS_THAN	INTEGER, DECIMAL, FLOAT, DATE, DATETIME
LESS_THAN_OR_EQUALS	INTEGER, DECIMAL, FLOAT, DATE, DATETIME