...
In this case, if we enable macros=true, the inner query executes first and it won't be able to find a substitution value for "directory_id". ThusTherefore, this query is not executed successfully.
...
In this case, if we enable macros=true, the inner query executes first and it won't be able to find a substitution value for "directory_id". ThusTherefore, this query is not executed successfully.