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​

This node is a condition. It can be added to the query branch directly after the root node or a logical node.

alt text

It can be populated with these nodes:

Options​

Select the node to access its options:

  • Swap - use a different comparison node. Any populated segments are kept, which limits the options.

  • Delete - remove the node from the query branch.

  • 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"
              }
            }
          ]
        }
      ]
    }
  ]
}