...
For more information on how to use this source code on your Confluence, read the following article:
Expand |
---|
title | Click here for the source code... |
---|
|
Code Block |
---|
<ac:structured-macro ac:macro-id="66ffc2d2-2b30-481a-b205-bbfa5cc3f886" ac:name="show-if" ac:schema-version="1">
<ac:parameter ac:name="user">
<ri:user ri:userkey="2c9180826b456b39016b456c262a0000"/>
</ac:parameter>
<ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
<ac:rich-text-body>
<ac:structured-macro ac:macro-id="6116a97d-98da-4b9b-a599-3769114684bd" ac:name="deck" ac:schema-version="1">
<ac:parameter ac:name="id">Admin View </ac:parameter>
<ac:rich-text-body>
<ac:structured-macro ac:macro-id="90d6f8bd-773e-48ef-897b-c96120d7c446" ac:name="card" ac:schema-version="1">
<ac:parameter ac:name="label">Filter By User</ac:parameter>
<ac:rich-text-body>
<table class="wrapped relative-table" style="width: 26.3967%;">
<colgroup> <col style="width: 19.5286%;"/> <col style="width: 80.1347%;"/> </colgroup>
<tbody>
<tr>
<th>Select User</th>
<td>
<div class="content-wrapper">
<ac:structured-macro ac:macro-id="c2c5d941-92eb-498a-a21b-d20514199b8b" ac:name="list-data" ac:schema-version="1">
<ac:parameter ac:name="name">userSearch</ac:parameter>
<ac:parameter ac:name="type">auto complete</ac:parameter>
<ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
<ac:rich-text-body>
<ac:structured-macro ac:macro-id="2822037c-00b5-4f3e-a0e5-ed2e5bf0ea6a" ac:name="user-options" ac:schema-version="1">
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
</ac:rich-text-body>
</ac:structured-macro>
</div>
</td>
</tr>
</tbody>
</table>
<ac:structured-macro ac:macro-id="38d5eb12-68b2-4ab9-adba-e318f017cadb" ac:name="report-table" ac:schema-version="1">
<ac:parameter ac:name="injected">true</ac:parameter>
<ac:rich-text-body>
<ac:structured-macro ac:macro-id="cdf98a74-8378-4150-8723-ebacae1f3445" ac:name="expanding-reporter" ac:schema-version="1">
<ac:parameter ac:name="as">Task</ac:parameter>
<ac:parameter ac:name="">data:Task</ac:parameter>
<ac:rich-text-body>
<ac:structured-macro ac:macro-id="40c9aada-a259-4751-903d-8e02c1a875c9" ac:name="local-reporter" ac:schema-version="1">
<ac:parameter ac:name="">page:children</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<ac:structured-macro ac:macro-id="36cf05ae-9455-4f72-a42b-de0f17e215e3" ac:name="text-filter" ac:schema-version="1">
<ac:parameter ac:name="value">%data:userSearch>1%</ac:parameter>
<ac:parameter ac:name="">data:User</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="c4aa2d45-bc41-4bdf-9464-a59f5e2ce672" ac:name="report-column" ac:schema-version="1">
<ac:parameter ac:name="injected">true</ac:parameter>
<ac:parameter ac:name="title">Assignee</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="b8c14c79-53e0-4525-8a91-f2b6989404ed" ac:name="report-info" ac:schema-version="1">
<ac:parameter ac:name="">Task>data:User</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="6d8d1d54-748f-4e0f-b556-979d99a15ba9" ac:name="report-column" ac:schema-version="1">
<ac:parameter ac:name="title">Description</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="7d3e4e03-c535-4369-8fe8-9f4311318888" ac:name="report-info" ac:schema-version="1">
<ac:parameter ac:name="render">richtext</ac:parameter>
<ac:parameter ac:name="">Task>data:Description</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="b6209faf-9884-43c0-b8e6-befcda7d1dc8" ac:name="report-column" ac:schema-version="1">
<ac:parameter ac:name="title">Due Date</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="97bd7c3a-800c-4bd8-9c19-407e2687fd63" ac:name="report-info" ac:schema-version="1">
<ac:parameter ac:name="format">dd MMMM, yyyy</ac:parameter>
<ac:parameter ac:name="">Task>data:Due Date</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="6fabb5cc-ddd3-4a07-8eee-704d5946065a" ac:name="report-column" ac:schema-version="1">
<ac:parameter ac:name="title">Status</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="90b3c925-27ad-4bf0-8ebb-9adc07b68de6" ac:name="report-info" ac:schema-version="1">
<ac:parameter ac:name="">Task>data:Status</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="c9d1a5b4-768a-446b-9af6-4676a5fbbf52" ac:name="report-footer" ac:schema-version="1">
<ac:rich-text-body>
<table class="wrapped relative-table" style="width: 20.6701%;">
<colgroup> <col style="width: 27.5482%;"/> <col style="width: 72.4518%;"/> </colgroup>
<tbody>
<tr>
<td class="highlight-red" colspan="2" data-highlight-colour="red" style="text-align: center;" title="Background colour : Red">
<p title="">Total Number of Tasks: </p>
<div class="content-wrapper" title="">
<p>
<ac:structured-macro ac:macro-id="4ca0475c-c031-462a-a1ab-a5423757c1c1" ac:name="report-info" ac:schema-version="1">
<ac:parameter ac:name="">report:query>size</ac:parameter>
</ac:structured-macro>
</p>
</div>
</td>
</tr>
</tbody>
</table>
</ac:rich-text-body>
</ac:structured-macro>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<br/>
</p>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="932745d7-2098-41a5-b069-16e3f7846f09" ac:name="card" ac:schema-version="1">
<ac:parameter ac:name="label">Filter By Due Date</ac:parameter>
<ac:rich-text-body>
<table class="wrapped relative-table" style="width: 28.5255%;">
<colgroup> <col style="width: 18.2762%;"/> <col style="width: 81.4123%;"/> </colgroup>
<tbody>
<tr>
<th>Select Date</th>
<td>
<div class="content-wrapper">
<ac:structured-macro ac:macro-id="7ff4828b-b855-41d4-bdfb-b83344a842c7" ac:name="date-data" ac:schema-version="1">
<ac:parameter ac:name="format">dd-MMM-yyyy</ac:parameter>
<ac:parameter ac:name="name">dateSearch</ac:parameter>
<ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
</ac:structured-macro>
</div>
</td>
</tr>
</tbody>
</table>
<ac:structured-macro ac:macro-id="9d6dc1af-3c46-4cc7-91fd-3cf07cbee480" ac:name="report-table" ac:schema-version="1">
<ac:parameter ac:name="injected">true</ac:parameter>
<ac:rich-text-body>
<ac:structured-macro ac:macro-id="e25a034f-400a-4326-877b-30a526c94b9b" ac:name="expanding-reporter" ac:schema-version="1">
<ac:parameter ac:name="as">Task</ac:parameter>
<ac:parameter ac:name="">data:Task</ac:parameter>
<ac:rich-text-body>
<ac:structured-macro ac:macro-id="e59b95f0-492a-4d6a-a3b7-ebbdac3bd0ca" ac:name="local-reporter" ac:schema-version="1">
<ac:parameter ac:name="">page:children</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<ac:structured-macro ac:macro-id="232bf2d1-2dc3-4f12-9ead-c77c67b93198" ac:name="number-filter" ac:schema-version="1">
<ac:parameter ac:name="aboveValue">%data:dateSearch>milliseconds%</ac:parameter>
<ac:parameter ac:name="">data:Due Date>milliseconds</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="b1ceaa1b-c8f2-44e9-a7a6-7b729e35de74" ac:name="report-column" ac:schema-version="1">
<ac:parameter ac:name="injected">true</ac:parameter>
<ac:parameter ac:name="title">Assignee</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="f8525054-5998-4377-acd1-bdd512776a3d" ac:name="report-info" ac:schema-version="1">
<ac:parameter ac:name="">Task>data:User</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="cd901fc3-200e-44b0-b93c-4a97e2acb564" ac:name="report-column" ac:schema-version="1">
<ac:parameter ac:name="title">Description</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="ec152cf0-e456-46f4-9f92-5927571104be" ac:name="report-info" ac:schema-version="1">
<ac:parameter ac:name="render">richtext</ac:parameter>
<ac:parameter ac:name="">Task>data:Description</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="6d6842de-22d9-40ba-ac84-f99d83c51d5b" ac:name="report-column" ac:schema-version="1">
<ac:parameter ac:name="title">Due Date</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="74d0445f-1dad-4603-aea9-69c9d89c9a82" ac:name="report-info" ac:schema-version="1">
<ac:parameter ac:name="format">dd MMMM, yyyy</ac:parameter>
<ac:parameter ac:name="">Task>data:Due Date</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="8be7b5f3-d115-4ed3-91ff-d36a9b7bb752" ac:name="report-column" ac:schema-version="1">
<ac:parameter ac:name="title">Status</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="dbd2ea20-c19f-497b-94ef-ec64944198bc" ac:name="report-info" ac:schema-version="1">
<ac:parameter ac:name="">Task>data:Status</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="7bea169e-288f-44a3-81be-0f07e069ff90" ac:name="report-footer" ac:schema-version="1">
<ac:rich-text-body>
<table class="wrapped relative-table" style="width: 20.6701%;">
<colgroup> <col style="width: 27.5482%;"/> <col style="width: 72.4518%;"/> </colgroup>
<tbody>
<tr>
<td class="highlight-red" colspan="2" data-highlight-colour="red" style="text-align: center;" title="Background colour : Red">
<p title="">Total Number of Tasks: </p>
<div class="content-wrapper" title="">
<p>
<ac:structured-macro ac:macro-id="b37aa8bf-5719-4fd8-b07a-cb9b6a38e987" ac:name="report-info" ac:schema-version="1">
<ac:parameter ac:name="">report:query>size</ac:parameter>
</ac:structured-macro>
</p>
</div>
</td>
</tr>
</tbody>
</table>
</ac:rich-text-body>
</ac:structured-macro>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<br/>
</p>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="5fe41a7c-bc08-4b76-bc81-67b6bf7d9567" ac:name="card" ac:schema-version="1">
<ac:parameter ac:name="label">Filter By Status</ac:parameter>
<ac:rich-text-body>
<table class="wrapped relative-table" style="width: 25.971%;">
<colgroup> <col style="width: 22.5873%;"/> <col style="width: 77.3443%;"/> </colgroup>
<tbody>
<tr>
<th>Select Status</th>
<td>
<div class="content-wrapper">
<ac:structured-macro ac:macro-id="6956bcb8-9967-4e44-906c-59c042f87974" ac:name="list-data" ac:schema-version="1">
<ac:parameter ac:name="name">statusSearch</ac:parameter>
<ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
<ac:rich-text-body>
<ac:structured-macro ac:macro-id="f1956060-e6bd-4959-993f-c3122deae231" ac:name="list-option" ac:schema-version="1">
<ac:parameter ac:name="value">Open</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="f9d8f4e1-d373-4bd7-94d9-07aeb90a939f" ac:name="list-option" ac:schema-version="1">
<ac:parameter ac:name="value">In Progress</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="3347e340-dd00-4b6a-969d-a8261c73d384" ac:name="list-option" ac:schema-version="1">
<ac:parameter ac:name="value">Done</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
</ac:rich-text-body>
</ac:structured-macro>
</div>
</td>
</tr>
</tbody>
</table>
<ac:structured-macro ac:macro-id="7302f6ce-b193-4091-9349-ebbcc1391100" ac:name="report-table" ac:schema-version="1">
<ac:parameter ac:name="injected">true</ac:parameter>
<ac:rich-text-body>
<ac:structured-macro ac:macro-id="9c746784-f82c-41c9-9c40-ca77abda98a2" ac:name="expanding-reporter" ac:schema-version="1">
<ac:parameter ac:name="as">Task</ac:parameter>
<ac:parameter ac:name="">data:Task</ac:parameter>
<ac:rich-text-body>
<ac:structured-macro ac:macro-id="84fbdea6-927f-45a5-a16d-ea1a15599980" ac:name="local-reporter" ac:schema-version="1">
<ac:parameter ac:name="">page:children</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<ac:structured-macro ac:macro-id="8928baab-faa0-48d1-91dc-107f11376696" ac:name="text-filter" ac:schema-version="1">
<ac:parameter ac:name="value">%data:statusSearch>1%</ac:parameter>
<ac:parameter ac:name="">data:Status</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="218c8e0a-a4a1-433a-aa9f-5eb3e32ef7b4" ac:name="report-column" ac:schema-version="1">
<ac:parameter ac:name="injected">true</ac:parameter>
<ac:parameter ac:name="title">Assignee</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="8720d5ed-58df-489b-9926-06c0c6e15cc6" ac:name="report-info" ac:schema-version="1">
<ac:parameter ac:name="">Task>data:User</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="6c5b0d65-2592-4f49-8c1b-96e80b9c6c70" ac:name="report-column" ac:schema-version="1">
<ac:parameter ac:name="title">Description</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="3b19141c-3b2a-4984-a453-a698644f6869" ac:name="report-info" ac:schema-version="1">
<ac:parameter ac:name="render">richtext</ac:parameter>
<ac:parameter ac:name="">Task>data:Description</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="e978cea1-0517-4e8d-b855-7ccfa33b8a60" ac:name="report-column" ac:schema-version="1">
<ac:parameter ac:name="title">Due Date</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="e05cb75c-7591-486b-b54a-d8f7e794975a" ac:name="report-info" ac:schema-version="1">
<ac:parameter ac:name="format">dd MMMM, yyyy</ac:parameter>
<ac:parameter ac:name="">Task>data:Due Date</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="6066009f-2a29-4136-a946-c5fb66db4460" ac:name="report-column" ac:schema-version="1">
<ac:parameter ac:name="title">Status</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="e80d0543-d234-46f9-a693-7ba7072a8664" ac:name="report-info" ac:schema-version="1">
<ac:parameter ac:name="">Task>data:Status</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="7359abff-9584-4cbf-be6a-45c698b90497" ac:name="report-footer" ac:schema-version="1">
<ac:rich-text-body>
<table class="wrapped relative-table" style="width: 20.6701%;">
<colgroup> <col style="width: 27.5482%;"/> <col style="width: 72.4518%;"/> </colgroup>
<tbody>
<tr>
<td class="highlight-red" colspan="2" data-highlight-colour="red" style="text-align: center;" title="Background colour : Red">
<p title="">Total Number of Tasks: </p>
<div class="content-wrapper" title="">
<p>
<ac:structured-macro ac:macro-id="6383b625-e2cc-4e3a-8621-5217fa075ace" ac:name="report-info" ac:schema-version="1">
<ac:parameter ac:name="">report:query>size</ac:parameter>
</ac:structured-macro>
</p>
</div>
</td>
</tr>
</tbody>
</table>
</ac:rich-text-body>
</ac:structured-macro>
</ac:rich-text-body>
</ac:structured-macro>
</ac:rich-text-body>
</ac:structured-macro>
</ac:rich-text-body>
</ac:structured-macro>
</ac:rich-text-body>
</ac:structured-macro>
|
|
...
- Continuing on from the Show If macro we created in Part 4, add a Deck of Cards macro under the Chart macro we already created there.
Set its id parameter to "Admin View".
- Within the Deck of Cards (Archived) macro, add three Card (Archived) macros.
Set their labels to "Filter By User", "Filter By Due Date", and "Filter By Status".
- Inside the "Filter By User" Card macro,do as follows:
- Add a 2x1 table, enter "Select User" in the first column and add a List Data macro in the second column.
Set its name to "userSearch" and set its type to "auto complete" - Add a User Options macro within the List Data macro.
- Create a Report Table macro and within it create an Expanding Reporter and set its Key and As parameters to "
data:Task
" and "Task" respectively. - Within the Expanding Reporter macro, create a Local Reporter macro and set the Key parameter to "
page:children
". - Within the Expanding Reporter macro, add a Text Filter macro. Set the Key and Exact Value to "
data:User
" and "%data:userSearch>1%
" respectively. - Within the Report Table add four Report columns and set their title to "Assignee", "Description", "Due Date" and "Status" respectively.
In the "Assignee" Report column, add a Report Info macro and set its Key parameter to "Task>data:User
".
In the "Description" Report column, add a Report Info macro and set its Key parameter to "Task>data:Description
".
- In the "Due Date" Report column, add a Report Info macro and set its Key parameter to "
Task>data:Due Date
". - In the "Status" Report column, add a Report Info macro and set its Key parameter to "
Task>data:Status
". - Add a Report Footer macro.
- Add a 1x1 table in the Report Footer macro. Color it as desired. (Orange is used in this example.)
- Within the Report Footer macro, write "Total Number of Tasks:" and add a Report Info macro and set its Key parameter to "
Report:query>size
".
- Inside the "Filter by Due Date" Card (Archived) macro, do as follows:
- Add a 2x1 table, write "Select Date" in the first column.
Add a Date Data macro.
Set its name to "dateSearch" in the second column. - Create a Report Table macro.
- Within the Report Table macro, create an Expanding Reporter macro.
Set its Key and As parameters to "data:Task
" and "Task" respectively. - Within the Expanding Reporter macro, create a Local Reporter macro and set its Key parameter to "
page:children
". - Within the Expanding Reporter macro, add a Number Filter macro.
Set its Key and Above Value parameters to "data:Due Date>milliseconds
" and "%data:dateSearch>milliseconds%"
respectively - Within the Report Table add four Report columns and set their title to "Assignee", "Description", "Due Date" and "Status" respectively.
In the "Assignee" Report Column macro, add a Report Info macro and set its Key parameter to "Task>data:User
".
In the "Description" Report Column macro, add a Report Info macro and set its Key parameter to "Task>data:Description
".
- In the "Due Date" Report Column macro, add a Report Info macro and set its Key parameter to "
Task>data:Due Date
". - In the "Status"Report Column macro, add a Report Info macro and set its Key parameter to "
Task>data:Status
". - Add a Report Footer macro.
- Add a 1x1 table in the Report Footer macro. Color it as desired. (Orange is used in this example).
Write "Total Number of Tasks:" and Add a Report Info macro and set its Key parameter to "Report:query>size
".
Inside the "Filter By Status" Card (Archived) macro, do as follows:
- Add a 2x1 Table, write "Select Status" in the first column and add a List Data macro.
Set its name to "statusSearch" in the second column. - Within the List Data macro, add 3 List Option macros.
Set their Value parameters to "Open", "In Progress", and "Done" respectively. - Create a Report Table macro.
- Within the Report Table macro, create an Expanding Reporter macro.
Set its Key and As parameters to "data:Task
" and "Task" respectively. - Within the Expanding Reporter macro, create a Local Reporter macro.
Set its Key parameter to "page:children
". - Add a Text Filter macro within the Expanding Reporter macro.
Set its Key and Exact Value to "data:Status
" and "%data:statusSearch>1%
" respectively. - Within the Report Table macro, add four Report Column macros.
Set their title to "Assignee", "Description", "Due Date" and "Status" respectively. In the "Assignee" Report Column macro, add a Report Info macro and set its Key parameter to "Task>data:User
".
In the "Description" Report Column macro, add a Report Info macro and set its Key parameter to "Task>data:Description
".
- In the "Due Date" Report Column macro, add a Report Info macro and set its Key parameter to "
Task>data:Due Date
". - In the "Status"Report Column macro, add a Report Info macro and set its Key parameter to "
Task>data:Status
". - Add aReport Footer macro.
- Add a 1x1 table in the Report Footer macro.
Color it as desired. (Orange is used in this example.) - Within the Report Footer macro, write "Total Number of Tasks:" and add a Report Info macro and set its Key parameter to "
Report:query>size
".
...