Essentially, I’m trying to put a
WHERE statement inside a dataview field and filter a list of inlinks–AS a field–where
mother-location = file.name. So, notes that link to the current note, but ONLY if they link to it throught the
TABLE filter(file.inlinks, mother-location = file.name) FROM "Wiki/Locations"
This query doesn’t work, but you can probably see what I’m trying to do.
It seems so simple, and yet I just can’t figure out how this would work. I assume I need to use the
filter() function, but I can’t figure out how that works, either.
I’ve tried this query:
TABLE filter(file.inlinks, (x) => contains(x.mother-location, file.name)) AS Sub-Locations FROM "Wiki/Locations"
I’m not sure if I’m understanding
filter() correctly, but I’m trying to filter inlinks to only those where mother-location contains the file name of the current note in the table. So, I’m kind of trying to use
WHERE but as a field.
I am very confused as to how to get this working.