Dataview Query Questions
First, thank you for taking some time to look at this! I appreciate it a lot.
What am I attempting to do?
I want a dataview query to get the outlinks from all notes within a specific folder. (Meetings in the example data) But, I only want to show the outlinks which point to notes in another specific folder (Resources in the example data) and only show them once in the result.
I’ve been able to get the query to show the outlinks from the notes in the folder that link to the notes of the second folder but I am having trouble making the list/table show only unique results.
My Query so far.
TABLE WITHOUT ID filter(file.outlinks, (x) => contains(x.file.folder, "TEST/Resources")) AS "Meeting Resources" FROM "TEST/Meetings" WHERE contains(file.outlinks.file.folder, "TEST/Resources")
The structure of my data.
The outlinks from any note within the Meetings folder that link to notes within the Resources folder is what I want to show in the query results.
filter(file.outlinks, (x) => contains(x.file.folder, “TEST/Resources”)) is accomplishing this in combination with the FROM and WHERE commands. But, let us say that Meeting01 and Meeting02 both contain links to Resource01. The query gives me two results for that link. One link from each of the notes the query found that had outlinks matching the filter.
What I’ve tried so far.
I’ve had a look at:
for help which has gotten me this far. And I think I might be close to something, and maybe I just need to understand the Filter, Min, and Length Functions better.
Looking over the documentation for Dataview has been helpful but I am still lacking in understanding.
I’ll cut this post off here so it isn’t too long. I thank you for providing any help at all, even if just links to resources that might help me understand this better.
Here is a sample folder that you can put into a vault if you want to see a live version of what I’m attempting to build.
Sample_Data.zip (1.6 KB)