Filter Users Using Text Filter & User Reporter macros

Scenario

Combining Text Filter and User Reporter macros to filter and list certain users from the confluence-users group. 

Given the following Confluence users:

Result

Recipe

Apps

 

Reporting for Confluence Server & Data Center

 

Apps

 

Reporting for Confluence Server & Data Center

 

Level

Easy

Estimated time

10 minutes

Macros

Report Column, Report Info, Report Table, Text Filter, User Filter

Suppliers

Report Supplier, Text Supplier, User Supplier

Storage format

You can copy and paste this code into the Confluence Source Editor:

<ac:structured-macro ac:macro-id="60583f9e-30c0-4a45-8bb6-3392e00ad85e" 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="69abf7f4-375c-441b-992e-61ef27ab3cb0" ac:name="user-reporter" ac:schema-version="1"><ac:parameter ac:name="groups">confluence-users</ac:parameter><ac:rich-text-body> <p>&#xa0;<ac:structured-macro ac:macro-id="8b906441-d031-41dc-b35d-8f0b25eb41b8" ac:name="text-filter" ac:schema-version="1"><ac:parameter ac:name="include">.*gmail.*</ac:parameter><ac:parameter ac:name="">user:email</ac:parameter></ac:structured-macro></p></ac:rich-text-body></ac:structured-macro><ac:structured-macro ac:macro-id="4b7968ae-8f05-463f-b8f1-1a95d8d17db8" ac:name="report-column" ac:schema-version="1"><ac:parameter ac:name="injected">true</ac:parameter><ac:parameter ac:name="title">Confluence Users Who use Gmail</ac:parameter><ac:rich-text-body> <p><ac:structured-macro ac:macro-id="269b77e4-9e28-4e8e-a65e-ae8a31bcc5c7" ac:name="report-info" ac:schema-version="1"><ac:parameter ac:name="">user:email</ac:parameter></ac:structured-macro></p></ac:rich-text-body></ac:structured-macro></ac:rich-text-body></ac:structured-macro>

Macro structure

You can recreate the example in the editor view:

Steps

  1. Create Report Table macro. Check Injected parameter to set it to True.

  2. Within the Report Table, create User Reporter macro. Set Groups to "confluence-users".

  3. Within the User Reporter macro, create Text Filter macro and set the following parameters:
    Key: user:email
    Include: ".*gmail.*"

  4. Within the Report Table macro but outside User Reporter, create Report Column macro. Set the the following parameters:
    Title: "Confluence Users Who use Gmail"
    Injected: "checked"

  5. Within the Report Column macro, create Report Info macro. Set Key to user:email