setq
Executes a subquery and sets the key-value pair in the first record as the query parameter.
Syntax
setq [ SUBQUERY ]
Required Parameter
[ SUBQUERY ]
- Subquery command enclosed in a pair of square brackets (
[ ]
).
Description
This sets the field-value pair present in the first record of the result of executing the subquery as a query parameter. If the subquery returns one or more results, the command ignores them from the second record.
Subqueries consisting of setq
commands are executed before all other commands in the entire query command. If there are multiple setq
commands, they are executed sequentially.