Can "Current Page" be used in a Task Report

Jim_Leask

Is there a way to assign the "current page" in a task report, allowing it to report on all tasks assigned on that page?

We have meeting pages in Confluence, and frequently take the minutes and assign tasks on the page. We want to have a Task Summary report at the bottom of the same page that shows all tasks assigned in that meeting.

I can't create a Task Summary report with "Current Page" as the page. I can use the specific name of the page, however, if we copy the page to use as a template for the next meeting, the Task Report is wrong and need to be manually corrected.

Also, I would like this Task Report to report on all tasks together, as those are what is relevant for this page of work. The Task Status can only be "Incomplete" or "complete" but not both. 

Davin Studer

This could be done with a user macro that wraps the built-in task report macro and dynamically supplies the page property. See the below user macro.

Macro Name:
task_report_current_page

Macro Title:
Task Report Current Page

Macro Body Processing:
No macro body

Template:

## Developed by: Davin Studer
## Date created: 05/12/2020
## @param Label:title=Label(s)|type=string|required=false|desc=Only show tasks on pages with this label
## @param Assignees:title=Assigned to|type=username|required=false|multiple=true|desc=Only show tasks assigned to these people
## @param Creators:title=Created by|type=username|required=false|multiple=true|desc=Only show tasks created by these people
## @param Created:title=Created after|type=string|required=false|desc=Only show tasks created on or after this date. Dates must be entered as dd-mm-yyyy.
## @param Status:title=Task status|type=enum|enumValues=complete,incomplete|default=incomplete|desc=
## @param PageSize:title=Number of tasks per page|type=enum|enumValues=10,20,40|default=20|desc=
## @param Columns:title=Columns to display|type=string|required=false|default=description,duedate,assignee,location|desc=Allowed columns are description, duedate, assignee, location, completedate, labels
## @param Sort:title=Sort by|type=enum|enumValues=due date,assignee,page title|default=due date|desc=
## @param Reverse:title=Reverse sort|type=boolean|default=false|desc=

#if($paramAssignees && $paramAssignees != "")
    #set($assignees = $paramAssignees.split(","))
#end

#if($paramCreators && $paramCreators != "")
    #set($creators = $paramCreators.split(","))
#end

<ac:structured-macro ac:name="tasks-report-macro" ac:schema-version="1">
    <ac:parameter ac:name="pages">$content.id</ac:parameter>
    #if($paramLabel && $paramLabel != "")
    <ac:parameter ac:name="labels">$paramLabel</ac:parameter>
    #end
    #if($paramAssignees && $paramAssignees != "")
    <ac:parameter ac:name="assignees">
    #foreach($assignee in $assignees)
        <ri:user ri:userkey="$userAccessor.getUserByName($assignee).key"/>
    #end
    </ac:parameter>
    #end
    #if($paramCreators && $paramCreators != "")
    <ac:parameter ac:name="creators">
    #foreach($creator in $creators)
        <ri:user ri:userkey="$userAccessor.getUserByName($creator).key"/>
    #end
    </ac:parameter>
    #end
    #if($paramCreated && $paramCreated != "")
    <ac:parameter ac:name="createddateFrom">$paramCreated</ac:parameter>
    #end
    <ac:parameter ac:name="status">$paramStatus</ac:parameter>
    <ac:parameter ac:name="pageSize">$paramPageSize</ac:parameter>
    #if($paramColumns && $paramColumns != "")
    <ac:parameter ac:name="columns">$paramColumns</ac:parameter>
    #end
    <ac:parameter ac:name="sortBy">$paramSort</ac:parameter>
    <ac:parameter ac:name="reverseSort">$paramReverse</ac:parameter>
</ac:structured-macro>