I have several notes that have contact infos in them with the inline field [Kontakt: some info]. These notes all have some tags and they obviously have a name. What I want to achieve is a table with the columns “Tag”, “Kontakte”, “Notes”. In every row there should be only one tag in the first column, all the contact info on any note with this tag in the second column and links to all notes with that tag (and preferably at least one [Kontakt: …] in it) in the third column.
I have tried several querys, all only partly successful. For example:
TABLE WITHOUT ID tag AS Tags, rows.Kontakt AS Kontakte
FLATTEN file.tags AS tag
GROUP BY tag
That looks pretty decent (apart from the akward lists in the second column), but I can’t figure out how to add the file notes.
Any help greatly appreciated!