I'm creating a custom page layout that contains a CQWP that I'd like to display documents related to the page. The document library has a lookup column that relates to the page title in the Pages library. In the CQWP I've got a filter value of
I can't get the CQWP to display any documents. If I instead filter on a
"Single Line of Text" field where I manually type the Page Title, it works fine, so I know it's not an issue with the filter value.
I assume the issue is that the lookup field is actually returning something like
"1#;Page Title", but I don't know how to account for that in my filter.