Convert Static Query Into Dynamic Query Based on Current File Properties

Help
1

What I’m trying to do

Convert this query into something dynamic. I read something that it could be because the links are being seen as lists but when I try something I found that should make the lists into objects… it doesn’t work…

TABLE
WHERE contains(categories, [[PHCM - CCG]]) AND contains(project-status, [[1. Active Project - Next Action]]) AND contains(fileClass, Projects)

Things I have tried

TABLE
WHERE contains(categories, this.categories) AND contains(project-status, this.project-status) AND contains(fileClass, this.fileclass)

Also tried contains(flat(list(property)), this.property)

Here’s an example of my note properties:

---
fileClass:
  - Projects
Areas:
  - "[[1. PHCM - Billable]]"
Categories:
  - "[[PHCM - CCG]]"
Meetings: 
People: 
Projects: 
Project End Date: 
Deferred Date: 
Delegated Person: 
Note Title: CCG - Hub
Support Material: 
Date Created: 2025-02-18
Date Modified: 2025-05-06
Knowledge Content: 
Attachments: 
Project Status:
  - "[[1. Active Project - Next Action]]"
Project Priority:
  - "[[1. Urgent - Do Today]]"
---
2

I’m comparing my note properties and I see that in some cases the single item notes will show differently… Is that part of the problem?

fileClass:
  - Meetings

or

fileClass: Meetings

3

I don’t remember how this worked:

Well, I do have an upgraded version of it in my vault, but I cannot (will not) deconstruct it.
The linked material will get you going, if with some AI help.