adding a filter to the Page Properties Report Macro

[Deleted user]

This question is in reference to Atlassian Documentation: Page Properties Report Macro

HI,

I created a page properties report, and it is great. It displays the million pages i have with the relevant metadata ( properties). Now i want to be able to filter this table based on the properties in the table. However i only have the option to sort, not filter. Please assist!

And also, how do I add automatecly add predefined selection option and turn them into labels, like you do here on this question form,
When i open a new question, i need to select between the different parameters:

My questions is about JIRA/COnfluence?Hip CHat

Deployment: Server/cloud
Audience.... etc.
based on what i select, the labels change. 
How do I do it?

Thanks,

[Cam Mckerral]

I realise this is an old post, but it seems you can now use a logical operator (AND/OR) with the "including text" filter - such as "|Status|Open| AND |Project|Stuff|" - which seems to meet your needs Rob Woodgate.

[Rob Woodgate]

Hi Cam,

Do you mean you can use AND and OR within the text of the filter?

(And what are the pipes for?)

[scott_boisvert]

This works if you're searching for a specific text. Any idea how to do this if you're looking for a field that hasn't been populated, the field is empty?

@Rob Woodgate The pipes are the column and the text you're looking for.

EX. |Column Name|TEXT|

[Dean Robinson]

@Cam Mckerral - I am trying to do this with our version of Confluence where I want to filter the page properties report content based on the value of a field, but I cannot seem to get it to work. I have populated the "including text" filter with |Status|Review| - but it does not seem to apply the filter. Any idea if this capability exists?

[Elvar Böðvarsson]

Had this issue and the solution is to have the filter within quotation marks

Instead of just |Status|Review| have it "|Status|Review|"

[Kevin Portman]

To add to the great answers above, and combined with the information on CQL - https://support.atlassian.com/confluence-cloud/docs/insert-the-page-properties-report-macro/#CQL-fields - I used the following to split my Page Properties reports into active and inactive tables:

Active: "|Status|Done|" OR "|Status|Closed|" OR "|Status|Resolved|"

Inactive: -"|Status|Done|" OR "|Status|Closed|" OR "|Status|Resolved|"

Note: the NOT clause applies to the whole set, so you don't do -"|Status|Done|" AND -"|Status|Closed|" ;)

*Multiple statuses because of users across multiple teams working with different terms :|

[Rachel Bedi]

I am on Confluence data server and attempting to filter on the Status column in my page properties report as you've outlined above, I have tried both with and without quotations (single word statuses) and receive a "no content found" when the filter is applied (this is the case both with an OR statement for multiple status, and tested with a single status without an OR statement). Is the above only applicable with Confluence Cloud? 

[Amit Kumar]

Hi Maria,

You can use the table filter macro to filter the page properties report.

• Insert a table filter macro on your page.
• Drag and drop your page properties report report inside the table filter macro
• Edit table filter macro, use filter tab to add column filter
• Go to filteration tab and use "set filters' defeult value" to assign per populated values to your filters

Hope you find this useful.

[tcroots78]

Hi Amit, I was looking to add the table filter macro, but I couldn't find it. Can you give me more details on how to add it?

[Andrey Khaneev _StiltSoft_]

Hi John,

You can find Table Filter macro at Atlassian Marketplace.

[Martin Cleaver]

Note Confluence will still first retrieve all records. On the page Table Filter will hide those not matching. Use sparingly - doesn't scale well with and imposes a load.

[Rob Woodgate]

Hi Maria,

To filter in the Page Properties Report you have to use the filter options in the macro.  There are no filter options in the table itself.

[Deleted user]

Thank you, But the filter options within  the macro are very limited. For example, I can't use " include text" twice. Making it impossible to combine filter parameters. Are there any workarounds to it? Are there any Add-Ons to it? 

Thanks,

[Rob Woodgate]

Hi Maria,

Unfortunately there aren't any workarounds or specific page properties add-ons (that I'm aware of).  There are quite a few table add-ons that allow you to add filter rows, etc - perhaps one of those would work?

[tcroots78]

Is there a way to suggest that this be added? It seems like filtering to only see properties one wants would be incredibly useful in cases with many pages, like Maria's and mine.

[Igor DeFaye]

It's been several years and this feature is still lacking. Is there any improvement plans or is this just a stale macro ?