The Conditional node is used to determine which node will be executed next, based on a given condition. If the condition resolves to true, the first node (labeled 'true' in the flow) will be executed. If the condition resolves to false, the second ('false') node will be executed.
Two nodes must be connected to the conditional node; the first/ top node is automatically the 'true' condition, while the second/ bottom node is automatically the 'false' condition. This can be edited if needed.
Conditional Properties
Display Name
The default display name of the for loop node is SQL Switch 1. Any subsequent for loop nodes are named according to this naming convention, with the appropriate numeric suffix, e.g. 'Conditional 2', 'Conditional 3', etc.
You can change the Conditional node name from directly from this field.
Description
You have the option to add a description to each for loop node; this can be a useful way of documenting the node for yourself and other users.
Condition Expression
Write an expression that will resolve to either true or false.
Node Connection Properties
To edit the connection's link value (true or false), right click on the connection to open its Properties panel, then choose the required link value:
PQL Expressions
The Pyramid Query Language or PQL (pronounced 'Prequel') is a language built into Pyramid's PYRANA engine to allow users to construct queries that can run against the many SQL data stacks that Pyramid can query natively. PQL includes a vast array of operations and functions that allows users to query data and build analytical logic.
The Master Flow supports the use of the 'Common' PQL functions; when you open the PQL Editor, the Common PQL functions will be exposed, along with any variables that you've created within the flow.
To open the PQL Editor, click the PQL icon from the Condition Expression field.
Example
In this example, the Execute Process node is used to ping a URL, and the results are loaded into a variable called PingResult. The Conditional node is used to determine what happens next, based on the results of the ping. The Condition Expression is:
StartsWith(@PingResult, "Ping request could not find")
If the condition is true, the Email node will be executed. If the condition is false, the Set Variable node will be executed:
