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

[Daniel Tien]

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

[Stiltsoft support]

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]

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

[Stiltsoft support]

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.

[Stiltsoft support]

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