document-states-report macro

approvalName

all

The name of a content review.

• Leave empty to include all content

The name is defined by the {approval} macro and is shown in the Workflow Popup during Content reviews.

approvalAssignedTo

all

Should the report be filtered to content that the specified user(s) has been assigned to review? Value is one or more usernames separated by a comma..

• Leave empty to include all content
• Specify a username to filter to results which that user is assigned to review
• Specify @self to filter to results that the current user is assigned to review

Only applies if an approval name filter is specified, which stage of the content review should the content be in?

• pending – the review is not yet complete
• approved – the review was approved
• rejected – the review was rejected

title+, state, changed, updated by, updated

Report columns displayed can be set to be one or more of

From Comala Document Management 6.13:

• title
• state
• approvals
• approval status
• changed
• updated by
• updated

From Comala Document Management 6.16:

• approved version
• approved version approvers
• approved version date
• created
• due date
• readack status
• space
• workflow

Columns are displayed in the order the items are added in the macro editor.

+title item is always displayed.

filter

all

You can provide a comma-separated list of CQL filters in the form FieldName:Value – the values must be indexed.

• Workflow CQL Fields
• Advanced Searching Using CQL (Atlassian)
• CQL Field Reference (Atlassian)
• CQL Function Reference (Atlassian)
• CQL Keywords Reference (Atlassian)
• CQL Operators Reference (Atlassian) 
• Performing Text Searches with CQL (Atlassian)

label

Should the report be filtered by content label(s)?

• Leave empty to include all content
• Specify one label name to filter to a specific label
• List multiple label names, separated by commas, to filter to content with any of those labels

If using a list of labels, you can prefix the list with & (ampersand) to require that content has all the labels.

maxItems

20

The number of results to show per page.

order

descending

What order should results be sorted in?

• ascending – A→Z
• descending – Z→A

parent

Should the report be filtered to a specific parent page and the child pages of the specific page?

• Leave empty to include all content in the space
• Specify a page title to include the specified page and its child pages
• Specify @self to specify the current page

sort

modified

Which report column of the report should results be sorted by?

• modified – the most recent date on which the content (page or blog post) was modified
• pagestate – the current workflow state
• statechanged – the most recent date on which the state was changed
• title - the content title
• approval status - pending, approved, rejected
• approvals - approval name

space

current space

Which space(s) should be included in the report?

• Leave empty to report on the current space
• Specify one space key to report on a specific space
• List multiple space keys, separated by commas, to report on multiple spaces
• Specify any to report on all spaces

state

all

Should the report be filtered to specific state(s)?

• Leave empty to report on all states
• Specify one state name to report on that state
• List multiple state names, separated by commas, to report on specific states

Should the report be filtered to states in a specific workflow(s)?

• Leave empty to report on all states in all workflow
• Specify one workflow name to report on states in that workflow
• List multiple workflow names, separated by commas, to report on specific states in those workflows