The parameter "macros=true" has a limitation when using the nested SQL queries. For example, consider the use case below :
Following is an example of a SQL query where the output of the outer query is fed as input to the inner query.
Code Block |
---|
select ap.directory_id,
CONCAT('{sql-query:dataSource=SQLSERVER|table=false}
use jiradbnew;
select user_name, directory_id, display_name, email_address, dir.directory_position
from cwd_user usr
join cwd_directory dir on dir."id" = usr."directory_id" and dir."id"= ', ap.DIRECTORY_ID, ' {sql-query}') as "JiraVal"
from cwd_group ap |
In this case, if we enable macros=true, the inner query executes first and hence it does not yield proper result.
Include Page | ||||
---|---|---|---|---|
|