Examples for Entry Types - Dynamic Multi Select with Run Self-Service Reports for Confluence and SQL for Confluence apps

This article provides an example of Dynamic Multi-Select field types in Run Macro.

Instructions

Prerequisites: Install the Run Self-Service Reports for Confluence and SQL for Confluence apps. ENsure to have the permissions to use the macros.

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:

One Appfire Support Knowledge Base

Examples for Entry Types - Dynamic Multi Select with Run Self-Service Reports for Confluence and SQL for Confluence apps

Analytics

Instructions

Related content