Skip to main content

Is Set

Check whether an attribute holds a value​

Each node takes a single input to filter the queried items.

  • Is set - items qualify if the input holds a value.

  • Is not set - items qualify if the input is empty.

Usage​

These nodes are conditions, so you can add them directly after the root node or a logical node.

A root node connected to an Any node, which branches to an Is set node and an Is not set node, each with one empty segment

Compatibility​

The single segment must hold an Attribute or Property.

NodeAccepted Value TypeNotes
AttributeAny except GeometryUse the Pathfinder to choose an attribute, on the queried item or a linked item
PropertyAnyItems always have these properties, so Is set is always true and Is not set is always false

Options​

Select the node to access its options:

  • Swap - use another comparison node. If any segments are populated, only compatible nodes are listed.

  • Delete - remove the node from the query branch.

  • Link negated - invert the condition. Different from swapping to the opposite node. Only available when a segment references a linked design/interface.

Examples​

Is set​

Fetch all defects with attachments.

In AQS terms:

Fetch items of the Defects interface where their Attachments attribute is set.

An Is set node checking the Attachments attribute
See JSON code

This code may reference designs, interfaces, attributes or items that don't exist in your company project.

{
  "type": "Query",
  "properties": {
    "collectionCode": "Live",
    "dodiCode": "designInterfaces_defects"
  },
  "children": [
    {
      "type": "Exists",
      "children": [
        {
          "type": "Attribute",
          "properties": {
            "attributeCode": "attributes_filesAttachableAttachments"
          }
        }
      ]
    }
  ]
}

Is not set​

Fetch all jobs without an assigned team or team member.

In AQS terms:

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

An All node with two Is not set conditions, checking the Team and Team Member attributes
See JSON code

This code may reference designs, interfaces, attributes or items that don't exist in your company project.

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