adding a filter to the Page Properties Report Macro Edited

[M]

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,

[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.

[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|

[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.

[M]

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.