How to inject parameters into the Jira Issues macro

Scenario

The following recipe shows how to inject parameters into Atlassian's Jira Issue macro. Wiki Markup must be used as the macro auto-complete does not read the injection.

Both Scaffolding and Reporting must be installed with a connection between Confluence and Jira.

Result

Recipe

Apps	Scaffolding Forms & Templates for Confluence Server and Data Center, Reporting for Confluence Server & Data Center

Apps	Scaffolding Forms & Templates for Confluence Server and Data Center, Reporting for Confluence Server & Data Center
Level	Advanced
Estimated time	15 minutes
Macros	Report On
Suppliers

Storage format

You can copy and paste this code into the Confluence Source Editor:

<p>Project:</p>
<ac:structured-macro ac:macro-id="f8d910e0-a27a-4843-b07b-27b65eeb4382" ac:name="text-data" ac:schema-version="1">
  <ac:parameter ac:name="name">ProjectName</ac:parameter>
  <ac:parameter ac:name="content">text</ac:parameter>
  <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
  <ac:rich-text-body>
    <p>
      <br />
    </p>
  </ac:rich-text-body>
</ac:structured-macro>
<p>
  <br /> Start:</p>
<ac:structured-macro ac:macro-id="91ce2742-67ec-4045-a02a-25b3adbba42b" ac:name="date-data" ac:schema-version="1">
  <ac:parameter ac:name="name">SprintStart</ac:parameter>
  <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
</ac:structured-macro>
<p>
  <br /> End:</p>
<ac:structured-macro ac:macro-id="b51b50cd-3a72-483e-8b6c-14be8a2b823f" ac:name="date-data" ac:schema-version="1">
  <ac:parameter ac:name="name">SprintEnd</ac:parameter>
  <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
</ac:structured-macro>
<p class="auto-cursor-target">
  <br />
</p>
<ac:structured-macro ac:macro-id="b8518e14-916a-4136-a6b7-9bde65fbe7df" ac:name="report-on" ac:schema-version="1">
  <ac:parameter ac:name="injected">true</ac:parameter>
  <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
  <ac:rich-text-body>
    <ac:structured-macro ac:macro-id="491e8898-a643-4bee-b521-d4971c23ed0d" ac:name="jiraissues" ac:schema-version="1">
      <ac:parameter ac:name="jqlQuery">project = %data:ProjectName% AND resolved &gt; %data:SprintStart&gt;date:yyyy-MM-dd% AND resolved &lt; %data:SprintEnd&gt;date:yyyy-MM-dd% ORDER BY priority DESC</ac:parameter>
    </ac:structured-macro>
  </ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
  <br />
</p>

Macro structure

You can recreate the example in the editor view:

Steps

Create a Text Data macro.
Give it a Field Name of "ProjectName".
Change the Content Type to "Text".
Create a Date Data macro.
Give it a Field Name of "SprintStart".
Create another Date Data macro.
Give it a Field Name of "SprintEnd".
Create a Report On macro.
Ensure the Injected parameter is true.
Within the Report On macro, create a Jira Issues macro.
Enter a JQL query into the Search field.
In this example, the query used is:
project = %data:ProjectName% AND resolved > %data:SprintStart>date:yyyy-MM-dd% AND resolved < %data:SprintEnd>date:yyyy-MM-dd% ORDER BY priority DESC