Extract frontmatter field from inlinks files

[channingwalton]

Hi,
I have this:

TABLE file.inlinks AS "Links"
FROM "Journal/Daily Notes"
WHERE file.inlinks
SORT file.name DESC
LIMIT 5

Which produces this:

File           Links
---------------------
2024-09-26     - File A
               - File B
               - File C
2024-09-25     - File D
               - File A
               - File C
etc.

How can I add another column showing a value from the inlinked file's frontmatter.

File            Links      Key
------------------------------
2024-09-26     - File A    v1 (from File A's frontmatter)
               - File B    v2
               - File C    v3
2024-09-25     - File D    v4
               - File A    v1
               - File C    v3
etc.

[channingwalton]

The answer is that I can use file.inlinks.fieldName:

TABLE file.inlinks AS "Links", file.inlinks.epic AS "Key"
FROM "Journal/Daily Notes"
WHERE file.inlinks
SORT file.name DESC
LIMIT 5