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

Owned by Kinnera
Last updated: Jun 30, 2022 by Amith Mathur

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. 

  1. Create a page and add the macro Run with a user form and parameters.
  2. 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: