Less Than / Greater Than

Check whether one value exceeds another

Each node takes two inputs to filter the queried items.

Less than - items qualify if the first input is smaller than the second.
Greater than - items qualify if the first input exceeds the second.

Usage

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

Compatibility

Both segments must hold the same value type (a number, date or time). One reads from the queried items, the other provides the value to compare against. Attribute and Property can't be paired.

Node	Accepted Value Type	Notes
Attribute	Number, Date, Date Time, Time, Seasonal	Use the Pathfinder to choose one, on the queried item or a linked item
Property	Date Time	Only the Last edit date property is compatible. Use the Pathfinder to choose it, on the queried item or a linked item
Count	Number
Number	Number
Date / Date Time / Seasonal / Time	Date, Date Time, Seasonal, Time	Seasonal ignores the year, Time ignores the date
Relative Date / Relative Date Time	Date, Date Time	Derived each time the query runs
Value From Item Attribute	Same as its referenced attribute	From one or more items of any design/interface
Length	Number
Arithmetic nodes	Number

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.
Inclusive - enable this to make the condition "or equal to".
Link negated - invert the condition. Different from swapping to the opposite node. Only available when a segment references a linked design/interface.

Examples

Less than

Fetch all inspections completed before 2026.

In AQS terms:

Fetch items of the Inspections interface where their Completion Time attribute is less than 1 January 2026.

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_inspections"
  },
  "children": [
    {
      "type": "LessThan",
      "children": [
        {
          "type": "Attribute",
          "properties": {
            "attributeCode": "attributes_tasksCompletionTime"
          }
        },
        {
          "type": "DateTime",
          "properties": {
            "value": ["2026-01-01T00:00:00.000Z"]
          }
        }
      ]
    }
  ]
}

Greater than

Fetch all jobs with over 4 job work items.

In AQS terms:

Fetch items of the Jobs interface where the count of their Job Work Items attribute is greater than 4.

See JSON code

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

{
  "type": "Query",
  "properties": {
    "attributes": ["attributes_itemsTitle", "attributes_itemsSubtitle"],
    "collectionCode": "Live",
    "dodiCode": "designInterfaces_jobs"
  },
  "children": [
    {
      "type": "GreaterThan",
      "children": [
        {
          "type": "Count",
          "properties": {
            "groupBy": "attributes_jobsJobWorkItems"
          }
        },
        {
          "type": "Number",
          "properties": {
            "value": [4]
          }
        }
      ]
    }
  ]
}

Check whether one value exceeds another​

Usage​

Compatibility​

Options​

Examples​

Less than​

Greater than​