Skip to main content

Is Not Set node

​

Description​

The Is not set node takes one input. It filters the items in your query by checking if the specified attribute is empty.

Usage​

The Is not set node is a condition, so it can be added to the query branch directly after the root node or a logical node.

alt text
alt text

It can be populated with these nodes:

Configuration​

alt text

  • ​ Swap - change the comparison node. If any segments hold values, they'll remain but the node types offered will be limited.

  • ​ Delete - remove the node from the query.

  • Link negated - enable this to invert the condition imposed by the node. Items must now fail the condition to be included in the query results.

Example​

Fetch all jobs without an assigned team or team member

In full detail:

Fetch items of the Jobs interface where their Teams attribute is not set AND their Team Member attribute is not set

alt text
See JSON code
{
  "type": "Query",
  "properties": {
    "collectionCode": "Live",
    "dodiCode": "designInterfaces_jobs"
  },
  "children": [
    {
      "type": "And",
      "children": [
        {
          "type": "NotExists",
          "children": [
            {
              "type": "Attribute",
              "properties": {
                "attributeCode": "attributes_tasksTeam"
              }
            }
          ]
        },
        {
          "type": "NotExists",
          "children": [
            {
              "type": "Attribute",
              "properties": {
                "attributeCode": "attributes_tasksTeamMember"
              }
            }
          ]
        }
      ]
    }
  ]
}