Filtering Files in Dataview Table by Specific Conditions

Not sure if this can be solved, searched everywhere, and tried everything. But thanks in advance for trying :blush:

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 :blush:

I haven’t tried this, but wouldn’t something like this work:

from "specific directory"
where Home="specific value"
AND !outgoing([[specific note]])

The “specific directory” needs to be the full path from the root of your vault