...
In this case, if we enable macros=true, the inner query executes first and hence it does not yield proper result.it won't be able to find a substitution value for "directory_id" and won't be able to execute successfully.
...
In this case, if we enable macros=true, the inner query executes first and hence it does not yield proper result.it won't be able to find a substitution value for "directory_id" and won't be able to execute successfully.