The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
This question is in reference to Atlassian Documentation: Page Properties Report Macro
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,
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.
Hi Cam,
Do you mean you can use AND and OR within the text of the filter?
(And what are the pipes for?)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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|
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Maria,
You can use the table filter macro to filter the page properties report.
Hope you find this useful.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It's been several years and this feature is still lacking. Is there any improvement plans or is this just a stale macro ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Confluence Space Cleanup Play Complete our new Play with your team to declutter your shared workspace and power knowledge-sharing and collaboration. Download the PDF version of Play i...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.