Combine multiple operators in a single LQL.
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
- 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.
Including multiple operators in the same LQL expression can reduce the complexity of a playbook and make it more concise.
[ Operator or LQL Expression ] as TableName | [ Operator or LQL Expression ] as TableName
The following example shows three LQL expressions separated by the pipe
Each LQL expression is renamed with a table reference that is used in the subsequent LQL expressions.
[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
Updated about 2 years ago