Configure advanced filter expressions

To configure advanced filter expressions for a diagram, you need to complete the configuration via the diagram view JSON text editor.

Steps

  1. Add a simple filter, as described in Work with filters in a diagram view.
  2. Select the Text option, which is shown below the view name.
  3. Find the node on which you created the simple filter, and then change the IN operator to one of the following operators:
    • IN
    • NOT_IN
    • CONTAINS
    • NOT_CONTAINS
    • STARTS_WITH
    • NOT_STARTS_WITH
    • ENDS_WITH
    • NOT_ENDS_WITH
      Note The operators EXISTS and NOT_EXISTS don't work in advanced filter expressions for diagrams.
    • IN
    • NOT_IN
    • LESS
    • LESS_OR_EQUALS
    • GREATER
    • GREATER_OR_EQUALS
  4. Click Save.

Examples and additional information

Filtering by asset type is particularly useful for diagrams. When filtering a diagram by asset type, note that all subtypes are included, meaning they pass the filter along with the specified asset type.

{
 "layoutRegion": "flow",
 "id": "Report Attribute",
 "type": {
  "id": "00000000-0000-0000-0000-000000031027"
 },
 "filters": [
  {
   "operator": "IN",
   "values": [
    "00000000-0000-0000-0000-000000031027"
   ],
   "field": "assetType"
  }
 ]
},

You need to provide the value in Unix Epoch datetime, in milliseconds. This example is for a custom date attribute to be greater than 2020-okt-1.

{
 "operator": "GREATER",
 "values": [
  "1601483854000"
 ],
 "field": "dateAttribute_7ff7f6af-33d3-4fdf-8ac5-bf918606315f"
}

For more information, go to: