Filter pages in Page Properties Report by using like or wildcard on specific page property

Question

Background:

I have a Page Properties macro on several of my pages. One of the properties is "Team" and another is "Target".

I am using the Page Properties Report macro to show all pages where Team contains "Team B" and Target = "Winter 2025". I am doing this by using the "Contains text" field and this syntax:

"|Team|Team B|" AND "|Target|Winter 2025|"

Example pages and content

* Page 1: Team is "Team A"
* Page 2: Team is "Team B"
* Page 3: Team is "Team A,Team B"

Problem

I am struggling to get the Page Properties Report macro to filter down to pages those with "Team B" listed second as it is in Page 3 ("Team A,Team B")

I have tried:

Blake Moody · Answer

Thanks for sharing this, but I'd like to solve with the current functionality if possible.

Stiltsoft support · Answer

Hi @Blake Moody ,

If you are open to 3rd party apps, you can use our Table Filter, Charts & Spreadsheets for Confluence.

Our macros support macro generated tables (Page Properties Report, Jira Issues, etc.), so you'll be able to use advanced filters on the fly from the page view mode.

For your case, the Free text filter provided by the Table Filter macro seems to be the right solution.