Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Filtering Page Properties Report where the field name or value contains a space

Daniel Tien
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 21, 2024

I created a page properties report and had some success filtering it based on the the information that lives on page properties.

This thread was very helpful: https://community.atlassian.com/t5/Confluence-questions/adding-a-filter-to-the-Page-Properties-Report-Macro/qaq-p/209297

However, what I'm trying to do right now is to filter the page properties report to only show "Status = Not Started"

I've tried "|Status|Not Started|" and "|Status|"Not Started"|"

Neither seems to work. I'm not sure how to account for the space that lives within "Not Started"

I've also tried wildcard characters such as ? and *, but they didn't seem to work either.


Edit: Actually, I don't think the space is the issue. I tried filtering other fields with a space in it and those seems to work. I'm just not sure why this one specifically isn't working

1 answer

3 votes
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 21, 2024

Hi @Daniel Tien ,

That will be just my guess but nevertheless: the Page Properties Report macro may be very sensitive to special characters. For example, if your table contains the "M&M" column title, then it won't be shown in the report. But change it to "M and M" and everything will be ok.

So, maybe the space breaks the filtration? Try to change the status as NotStarted or smth. 

Daniel Tien
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 21, 2024

Thanks for your suggestion! But those didn't seem to work either =(

Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 21, 2024

And do you have any working filters for your report? You've mentioned that you "had some success filtering it".

Maybe the filters work for text columns and don't understand Status macros? Or you use any 3rd parties apps to create statuses?

If nothing works, maybe you should apply to the Atlassian support for some hints.

Like # people like this
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 22, 2024

Hi @Daniel Tien ,

Any success with the issue?

You haven't mentioned if you are open to 3rd party apps - our add-on that is Table Filter, Charts & Spreadsheets supports filtration on the fly both for manually created and macro generated tables (Page Properties Report, Jira Issues, etc.). 

Like # people like this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events