Filtering Games by prerequisite playing

Help
1

What I’m trying to do

I want to make it so that I can filter games in my base by games that I want to play next, whilst not displaying games that require me to have beaten a different game first

Things I have tried

So far I have notes listing the games that need to be beaten first, and I want to have it so that if Obsidian sees that all games contained in that property have all been beaten, then it can be seen as play next but it doesn’t seem to allow you to filter by the properties of a note inside a note if that makes sense, happy to clarify better if I don’t make sense, very new to obsidian

2

Given game notes with list property prerequisite games and checkbox property beaten, like:

---
beaten: false
prerequisite games:
  - "[[game 2]]"
  - "[[game 3]]"
---

… try this property formula as an example:

[
["☑️ no prequisites", note["prerequisite games"].isEmpty()],
[["⛔ still need to beat", note["prerequisite games"].filter(file(value).properties.beaten != true)].flat(), note["prerequisite games"].filter(file(value).properties.beaten != true).length > 0],
["✅ prerequisites beaten", true]
].filter(value[1])[0][0]

image
image881×438 33.8 KB