Confluence: Page Properties: Page Properties Report: Editing Report Macro: Filter Not working

I've created a Confluence page and added a Page Properties macro to it.  I'm now creating a Page Properties Report  based on the Page Properties macro.  When I go to edit the Page Properties Report there is a field called 'Including Text' which I can use to filter the data I am looking for.   The filter works for most text, but when I enter the text 'Deployed' it pulls back all data instead of just the data with the word 'Deployed' in it, any ideas?

For context, I've created a field called 'Release Status' which has the values "DRAFT", "PENDING RELEASE", "APPROVED FOR RELEASE", "DEPLOYED", and "ARCHIVED".  It's to track the status of a release.  I tried creating a dropdown list which I couldn't get to work and I tried creating a checkbox list but I couldn't get the filtering to work so I just use text for now.

 

 

1 answer

1 accepted

Hello Kevin,

You can use Table Filter macro to filter Page Properties Report.

Hi Andrey.

Thank you for your reply!  I did try using Table Filter but unfortunately the way I structured my Page Properties the column contained many values for other rows where I wanted to do a filter and selection for values in only one row - if that makes sense.

Screen Shot 2017-08-04 at 9.49.58 AM.png

As an example above, I want to filter on values in column A, row 3.  I was able to filter on column A but it would also bring back values in rows 1, 2, and 4.  So in my Page Properties report I want to be able to say, show me all forms that have Apples in column A, row 3.

Not sure I understood how your PPR macro shows this properties...

Do you have multiple rows in each PP table? And how those 4 rows from PP are displayed in a row in PPR? Are they concatenated like "Blue Toyota Apples Country"?

You can try to use Free text filter type, or set a Cell value delimeter (use \u0020 as a space character) for dropdown filters.

Andrey,

Thank you for your responses!  I think this is a case of I needed a couple days away from it and some help from an expert (you) that I was on the right path.  I was able to get this to work this morning using the table filter.  

I tried the table filter last week and couldn't get it to work but it works great today.

Thanks for your help!

You are welcome, Kevin! Glad you made it to work!

Hi Andrey, Kevin

Not sure if my problem is related. I have a table with 2 columns and 4 rows. Is it even possible to show all all the data from this PP in a PPR macro ?

 

Thanks

Sujith

Suggest an answer

Log in or Sign up to answer
Community showcase
Published 9 hours ago in Confluence Cloud

Happy holidays from our team to yours!

Hi Community!  2018 was filled with changes for our team, both big and small, and we've taken a lot of time to both celebrate our wins and recognize areas of improvement. One thing that we're a...

86 views 0 11
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you