Creating a Table: Filtering Files by Frontmatter and Excluding Linked Files in note

[MDRUK]

A big thank you in advance for any help with this. I've searched everywhere and spent hours trying to solve this!

Here is my problem

I’m trying to create a Dataview table in Obsidian that includes files based on specific criteria and also excludes certain files. Here’s what I’m looking to achieve:

Include Files: The table should include files that:

• Have the frontmatter field "Home" containing "Note-making - MOC", AND

• Are located in the directory: "00001. Zettelkasten System/0003. Notes/001. Reference Notes/Fleeting Notes", AND

• Exclude Files: The table should exclude files that are already linked in the "Note-making - MOC.md" file located at "00001. Zettelkasten System/0002. Maps of Content/Note-making - MOC".

Essentially, I want the table to show me what files I have marked in the "Home" frontmatter as "Note-making - MOC" that haven’t yet been added to the "Note-making MOC - MDR.md" file.

This where I have eventually reached, without it still working:

TABLE without ID
  file.link as "To Add to a MOC - Note-making MOC - MDR",
  round(max(0, (date(today) - date(file.ctime)).days)) AS "Days Live"
FROM
"00001. Zettelkasten System/0003. Notes/001. Reference Notes/Fleeting Notes"
WHERE 
contains(file.frontmatter["Home"], "Note-making - MOC")
AND
!contains(file.path, "00001. Zettelkasten System/0002. Maps of Content/Note-making - MOC")
AND 
length(filter(file.outlinks, (l) => l != "[[00001. Zettelkasten System/0002. Maps of Content/Note-making - MOC]]")) > 0

Here is the error I get

Dataview: Error:
-- PARSING FAILED --------------------------------------------------

4 | from "00001. Zettelkasten System/0003. Notes/001. Reference Notes/Fleeting Notes"
5 | where Home = "Note-making - MOC"

6 | and file.name not in (
| ^
7 | from "00001. Zettelkasten System/0002. Maps of Content/Note-making - MOC.md"
8 | where file.name

Expected one of the following:

'*' or '/' or '%', '+' or '-', '>=' or '<=' or '!=' or '=' or '>' or '<', 'and' or 'or', /FROM/i, EOF, FLATTEN [AS ], GROUP BY [AS ], LIMIT , Not a comment, SORT field [ASC/DESC], WHERE , whitespace

[MDRUK]

And here is a more simplified version of my above question (lol):

Here’s what I need dataview to do:

Include Files: The table should include note files that:

• Have a specific value in their “Home” frontmatter field.
• Are located in a specific directory in Obsidian.

Exclude Files: The table should exclude files that:

• Are already linked in a specific note file.

Thanks

[MDRUK]

I found the solution. When I have a MOC and I add front matter to a note linking it to the MOC, this will generate a table listing the files I still need to add to the MOC file itself. I add the query to the MOC file itself.

TABLE without ID
file.link as “To add to Note-making - MOC”,
round(max(0, (date(today) - date(file.ctime)).days)) AS “Days Live”
FROM “00001. Zettelkasten System/0003. Notes/001. Reference Notes/Fleeting Notes” AND -outgoing([])
WHERE contains(file.frontmatter[“Home”], “Note-making - MOC”) AND !filter(this.file.outlinks, (o) => contains(file.outlinks, o) OR contains(file.inlinks, o))
sort file.name asc