Subtract node

​

Description

The Subtract node takes two numbers as input and subtracts the first from the second, e.g. 8 - 6 = 2

Usage

The Subtract node is a function, so it can be added to the segments of comparison nodes and other functions.

It can be:

• added to these comparison nodes:

  • ​ Equals
  • ​ Greater than
  • ​ Less than
  • ​ Not Equals

• compared against, and populated with, these nodes:

  • ​ Attribute (of Number type)
  • ​ Count
  • ​ Number
  • ​ Length
  • all other Arithmetic nodes

Configuration

• ​ 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.

Example

Fetch all street lights with a column 2 metres shorter than this particular one

In full detail:

Fetch items of the Street Lights design where their Column Height attribute is less than the Column Height attribute of a particular Street Light item minus 2

See JSON code

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

{
  "type": "Query",
  "properties": {
    "collectionCode": "Live",
    "dodiCode": "designs_streetLights"
  },
  "children": [
    {
      "type": "LessThan",
      "children": [
        {
          "type": "Attribute",
          "properties": {
            "attributeCode": "attributes_streetLightsColumnHeight_5e1db714ca31500ad87c5d18"
          }
        },
        {
          "type": "Subtract",
          "children": [
            {
              "type": "ValueFromItemAttribute",
              "properties": {
                "attributeCode": "attributes_streetLightsColumnHeight_5e1db714ca31500ad87c5d18",
                "dodiCode": "designs_streetLights",
                "value": ["5d95cc05ca314f0a302da717"]
              }
            },
            {
              "type": "Number",
              "properties": {
                "value": [2]
              }
            }
          ]
        }
      ]
    }
  ]
}