Configure an advanced filter expression in a diagram view

To configure advanced filter expressions for diagrams, you have 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. Click the Text tab, to switch to the diagram view text editor.
  3. Find the node on which you created the simple filter and 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 do not work in advanced filter expressions for diagrams.
    • IN
    • NOT_IN
    • LESS
    • LESS_OR_EQUALS
    • GREATER
    • GREATER_OR_EQUALS
  4. Above the diagram, to the right, click Save.

Examples and additional information

Filtering by asset type is particularly useful for diagrams. When filtering a diagram by asset type, keep in mind 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 have 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 on configuring advanced filter expressions in the diagram view text editor, see: