What I’m trying to do
Show a list value in a grouped table while organizing the table by tag. Formatted as below, but with the Function column containing the property it’s looking for. The primary issue is that the third column always displays as ‘-’
What I’ve got so far (Image)
What I’ve got so far (Query)
TABLE
rows.Name AS Name,
rows.class AS Function
WHERE
(file-category="Organisation"
OR file-category="Business")
AND (contains(Location ,this.file.name)
OR contains(Location ,this.file.link))
FLATTEN file.etags AS "Category"
FLATTEN Name
GROUP BY file.link AS Name
GROUP BY rows.Category[0] AS "Category"
SORT Category
What I’ve got so far (Properties example)
Class:
- Assassins
tags: - Institution
Things I have tried
I’ve tried rearranging some of the code or swapping file.link and class around but then the file.link property information also disappears. I’ve also attempted to have the file.link property (Name column) have the Function property appear in brackets next to it, but it still appears as a ‘-’. I’m very new to Obsidian and code in general so any tips or explanations for a layman would be very much appreciated.