The LogicHub domain-specific language (DSL) operator allows you to include multiple operators within a single LQL expression.
- The operators must be separated by the pipe
|
symbol. - Each of the operators must be named so it can be used in the subsequent operators in the same LQL expression.
- You can refer to tables by their names within the same LQL expression.
Usage Details
Including multiple operators in the same LQL expression can reduce the complexity of a playbook and make it more concise.
LQL Command
[ Operator or LQL Expression ] as TableName | [ Operator or LQL Expression ] as TableName
Example
The following example shows three LQL expressions separated by the pipe |
symbol.
Each LQL expression is renamed with a table reference that is used in the subsequent LQL expressions.
LQL Command
[select *, user as user_root from root] as t1 | [select *, user as user_t1 from t1] as t2 | [select *, user as user_t2 from t2] as t3