How do I filter relations for (non-)emptiness of attributes?

Colin Parker

Updated January 05, 2021 12:29

Question

How do I filter relations for emptiness or non-emptiness of attributes?

You can use the following API to get relations by URI:

Get https://mpe-01.reltio.com/reltio/api/{tenant_ID}/relations/{URI}

You can use the following API to scan the relations by type:

GET https://mpe-01.reltio.com/reltio/api/{tenant_ID}/relations/_dbscan

Request Body

{
    "type" : "configuration/relationTypes/HasAddress",
      "pageSize" : 10
}

You can include a filter in the scan to filter by emptiness or non-emptiness of an attribute:

GET https://mpe-01.reltio.com/reltio/api/{tenant_ID}/relations/_dbscan

Request Body

{
  "type": "configuration/relationTypes/HasAddress",
  "pageSize": 1,
  "timeLimit": 3000,
  "filter": "missing(attributes.AddressRank)"
}

An example of a filter for non-emptiness of an attribute would be: "filter": "exists(activeness.endDate)"