Using Filter in Page properties macro by values using macro Status

Question

Hello,

Im trying to filter on a Page properties macro that are using the Status-macro inside a cell but cant get it to work.

Im able to filter on plain text but not on values that are using the status macro.

The cell is called "Teststatus" and it looks like this:

Including text: "|Column|value|"

1: No active filter, show both pages.
2: Trying to filter on pages with "YES" in the column Teststatus, no hits.
3: Trying to filter on pages with "NO" in the column Teststatus, two hits(?)
4: Example on when im filtering on plain text and gets a correct result.

Any ideas on how to be able to filter on values inside the Status macro?

*edit Im primarily looking for ways to solve it without additional apps if possible.

Br

N Holm · Answer

Thanks, i had hoped it would be able to be solved without any additional apps but its good to know that there are alternatives.

Stiltsoft support · Answer

Hi @N Holm ,

We can suggest trying the app that we develop - Table Filter, Charts & Spreadsheets for Confluence.

Our Table Filter macro supports macro generated tables (and the Page Properties Report macro as well) and recognizes Statuses/Handy Statuses/Emoticons.

If you are not familiar with the app, please book a live demo from the team - we'll be able to discuss your use cases.