This article will provide an example of Dynamic Multi-Select field types in Run Macro.
Instructions
Prerequisites: Install the Run Self-Service Reports for Confluence and SQL for the Confluence app.
- Create a page and add the macro Run with a user form and parameters.
- Within this macro, add SQL Query macro.
Usage: Ability to select multiple values of a column on the Run macro and execute the SQL queries, instead of inputting the values like in a Text field.
Sample Requirement: To view the users' data based on the selection of the username.
Configuration:
<p><br /></p><ac:structured-macro ac:name="run" ac:schema-version="1" ac:macro-id="8b9e6549-f9f4-4a60-80dd-79f0a4e05c78"><ac:parameter ac:name="replace">Users::?users:group,user:::dynamic-selectmulti:3:Jira50:SELECT%20user_name%20FROM%20cwd_user</ac:parameter><ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter><ac:rich-text-body>
<p class="auto-cursor-target">selected users are $user</p><ac:structured-macro ac:name="sql-query" ac:schema-version="1" ac:macro-id="cee3efa6-7b89-4a08-bc2c-4f0fad61284b"><ac:parameter ac:name="dataSource">Jira50</ac:parameter><ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter><ac:plain-text-body><![CDATA[select * from cwd_user where user_name IN ($user)]]></ac:plain-text-body></ac:structured-macro>
<p class="auto-cursor-target"><br /></p></ac:rich-text-body></ac:structured-macro>
<p><br /></p>
<p><br /></p>
<p class="enh-settings hidden" style="display: none;">{}</p>
Results: