Page Properties Report and filtering to Key/Value pairs

[Elvar Böðvarsson]

I have been using the trick in this tread with great success until now

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

The filter I have problems with is 

Including text = |State|Expired|

The values I am using for the "State" page property is either Active or Expired

Now one page is showing up when I filter to Expired but that page has they value Active. It even shows Active in the column.

I thought it could be because the page included the word "Expired" somewhere and the filter was working on the whole page but that word is not in the page at all.

What it does contain is the word "expire" in two places for a totally different Key/Value pair. And when I remove those words it does work properly.

Does this feature simply not work as stated in the link above and that the include filter searches in all values?

[Elvar Böðvarsson · Accepted solution]

Figured it out!

The Including Text filter needs to be within quotation marks

From

Including text = |State|Expired|

To

Including text = "|State|Expired|"