How to use macros parameter within nested SQL queries

The macros=true parameter has a limitation when used in nested SQL queries.

For example, consider the following use case where the output of an outer query is fed as an input to the inner SQL query:

select ap.directory_id,
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 macros is set to true, the inner query executes first, thus, substitution values for directory_id is not available. Therefore, this query is not executed successfully.

Find answers from the community.

Ask a question to the community.

Log a request with our support team.

Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2022 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.