Skip to main content

All node

​

Description​

The All node lets you chain multiple comparison nodes together by splitting the query into multiple branches.

Items must fulfil every one of the conditions on the attached branches in order to be fetched by the query.

Usage​

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

alt text

Configuration​

alt text

  • ​ Delete - remove the node from the query.

  • ​ Swap - change to a different logical node.

Example​

Fetch all jobs created between 15 March 2021 and 30 April 2021, sorted by priority

In full detail:

Fetch items of the Jobs interface where their Raised Time attribute is greater than 15 March 2021 AND less than 30 April 2021, sorted by their Priority attribute

To see this example built step-by-step, see Example 3 - Logical branches.

alt text
See JSON code
{
  "type": "Query",
  "properties": {
    "attributes": [
      "attributes_itemsTitle",
      "attributes_itemsSubtitle",
      "attributes_tasksRaisedTime",
      "attributes_tasksPriority"
    ],
    "collectionCode": "Live",
    "dodiCode": "designInterfaces_jobs",
    "sortInfo": {
      "attributeCode": "attributes_tasksPriority",
      "sortOrder": "Descending"
    }
  },
  "children": [
    {
      "type": "And",
      "children": [
        {
          "type": "GreaterThan",
          "children": [
            {
              "type": "Attribute",
              "properties": {
                "attributeCode": "attributes_tasksRaisedTime"
              }
            },
            {
              "type": "DateTime",
              "properties": {
                "value": ["2021-03-15T00:00:00.000Z"]
              }
            }
          ]
        },
        {
          "type": "LessThan",
          "children": [
            {
              "type": "Attribute",
              "properties": {
                "attributeCode": "attributes_tasksRaisedTime"
              }
            },
            {
              "type": "DateTime",
              "properties": {
                "value": ["2021-04-29T23:00:00.000Z"]
              }
            }
          ]
        }
      ]
    }
  ]
}