Canned Search for Confluence
Breadcrumbs

Two Dimensional Contributor Summary Report

This macro display a summary of what each contributor has done to the pages returned by CQL query. It has the following features.

  • Support sorting by each column header

  • Display the users by row or column

  • Clicked on the number to display the related content in a popup dialog

cql2d.png

Configuration

Basic Settings

Field Name

Default Value

Explanation

Additional Information

Duration

This Month

Select the last modified duration to filter the result

  • This Week

  • This Month

  • Last Week

  • Last Month

  • Custom Duration


Custom Duration


If you select Custom Duration, enter a valid CQL Last Modified syntax.

Note:

  • Max 2 last modified dates.

    • Eg. lastmodified > startOfWeek() and lastmodified < endOfWeek()

Display Mode

Display users by row

Select the display mode for users

  • Display users by row

  • Display users by column


No. of Results per Page

10

Select the no. of results to be displayed:

  • 5 — Pagination will occur if there are >5 search results

  • 10 — Pagination will occur if there are >10 search results

  • 50 — Pagination will occur if there are >50 search results

  • 100 — Pagination will occur if there are >100 search results

If there are more results than the selected no. of results to display, pagination will occur.

Show advanced settings

Unchecked

when this option is checked, the advanced settings will be shown.



Advanced Settings

Field Name

Default Value

Explanation

Additional Information

CQL


Enter a CQL statement with $$query$$ or $$query*$$ as the search term.

Search Type

Exact Match

Select the type of search for $$query$$:

  • Exact Match

  • Start With

  • Contains

Default Query Term


Enter a default query term to replace the $$query$$ in CQL.
Search results will be preloaded if it is provided.

  • Note: $self returns current page title

Custom "No Results Found" message


Enter a customised message when no results are found.