Greater Than node
Description
The Greater than node takes two inputs. It filters the items in your query by checking if the first input is greater in value than the second input.
Usage
The Greater than node is a condition, so it can be added to the query branch directly after the root node or a logical node.
It can be populated with these nodes:
- Count
- Length
- Date and Date Time
- Number
- Relative Date and Relative Date Time
- Seasonal
- Time
- Value From Item Attribute
- all the Reference nodes
- all the 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 from the query.
-
Inclusive - enable this to make the condition "greater than or equal to".
-
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 with over 4 job work items
In full detail:
Fetch items of the Jobs interface where the count of their Job Work Items attribute is greater than 4
See JSON code
{
"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]
}
}
]
}
]
}