Tasks Report Macro

Similar to the original Tasks Report Macro provided by Confluence, but allows to select on document with a Where clause.

ID: projectdoc-tasks-report-macro
Since: 4.7
Page Size Support

Confluence Inline Tasks with projectdoc filters. In case you want to select on spaces and pages, please use the original Tasks Report Macro.

Also use the original macro to select from any locations.

Parameters

Where

Provide a Lucene search expression to select pages to fetch tasks from.

Example Constraints

$<Categories>=[Production]
$<Categories>=[Production] AND $<Tags>~(Platinum, Gold, Standard)

See Search Tips for more information on how to create a query.

There is a maximum amount of pages returned by this query. Per default this value is 100. The value can be adjusted by the space property projectdoc.tasks-report-macro.maxInitialPages.

Note that tasks from child pages of pages in the result list are also included.

Assigned to

Only show tasks assigned to these people.

This value is passed to the original macro.

Created by

Only show tasks created by these people.

This value is passed to the original macro.

Created after

Dates must be entered as dd-mm-yyyy (day, month, and year).

This value is passed to the original macro.

Task status

Only tasks of the specified status are displayed.

Valid values are incomplete (default) and complete.

This value is passed to the original macro.

Page size

Specify the number of tasks per page in the result list.

This value is passed to the original macro.

Columns to display

Allowed columns are

description
duedate
assignee
location
completedate
labels

Defaults to description,duedate,assignee,location.

This value is passed to the original macro.

Sort by

Specify the sort order of the tasks in the result list.

Valid values are

due date
assignee
page title

Defaults to due date.

This value is passed to the original macro.

Reverse sort

Check this option if you want the sort order of the tasks to be reversed.

Defaults to false.

This value is passed to the original macro.

Details

Data Center Compatibility

To support Atlassian Data Center the macro will limit the number of documents to use for fetching tasks. If the result set is larger than the maximum number of documents, an error message is rendered.

For more information, please refer to Limitations on Query Results.

Since 6.0

The limitation is checked since version 6.0.

References

Limitations on Query Results: The number of hits for document queries is limited due to performance reasons.

Resources

Display Table Macro: Lists references to projectdoc documents in a table. Allows to select document properties for columns. Also non-list representations are provided.
Code Block Placeholder Macro: Passes a text containing placeholders to the Code Block Macro. The placeholders are replaced by the properties of a document and/or the space properties.
Search Tips: Tips on specifying search queries for Lucene. This also applies to projectdoc's query macros.
Confluence Task Report Macro: Add the Task Report macro to a page to display a list of tasks. Filter the tasks by space, page, user, label, created date and more. This is the original macro provided by Confluence. It allows to select by spaces, pages, and labels, while the projectdoc version of the macro allows to select by a Where constraint.
Max Initial Page for the Tasks Report Macro: Allows to specify the maximum number of pages matching the Where Constraint of the Tasks Report Macro.