The five steps of a query sequence are:
Execution option implementation
LET and INITIALIZATION statement evaluation
Minor query block evaluation
FINAL and FINAL SHOW statement evaluation
Report filtering
However, given that LET statements may assign a range of values to a variable, a better picture of the execution sequence can be illustrated with the following code.
Implement execution options
Evaluate the INITIALIZE statements
For each LET value.
For each date to test
For each query block
IF the condition is true
THEN perform the action
End For
End For
End For
Evaluate the FINAL statements
ImplementTOP / BOTTOM / AS_LONG_AS filters
There can be n LET statements within the second major query block, therefore for each one, a “For each LET” loop is added to the nest. |
Time Offset – syntax detail
1 day ago / later
previous / next <condition>
Attribute Units – syntax detail
[1-99] [minutes|hours|days|weeks|months|quarters|years]