Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

adding a filter to the Page Properties Report Macro Edited

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,

3 answers

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.

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?

Hi John,

You can find Table Filter macro at Atlassian Marketplace.

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.

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?)

scott_boisvert Community Leader Jan 22, 2020

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|

Like Diogo Melo likes this

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.

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,

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?

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.

Like Ketenbeheer eHerkenning likes this

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

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

🥓🙅🏻‍♀️ Meet-less May Badge!

Hello Confluence Community!  What if i told you that you could have a healthier life and be 100% meet-less? This month, we're promoting a healthy, balanced work diet with Confluence. We la...

211 views 2 13
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you