Here’s a task even ChatGPT couldn’t solve. So, if you find a solution, you’re at least smarter than AI.
What I’m trying to do
I have a folder called “People” and a folder called “Journal.” Both have notes organized in subfolders. Notes in “Journal” mention notes from “People.”
I’m trying to make a list that arranges notes from “People” by their latest mention in the “Journal” folder in ascending order. I.e., I want to see first friends whom I haven’t seen for the longest.
Special kudos if the subfolder, where the “Person” note is located, could be added to the table or list.
Things I have tried
My current Dataview code produces a list of all notes in “People” and the dates when they are mentioned in the “Journal”:
list rows.file.link
from "Journal"
flatten file.outlinks as person
where contains(person.file.folder, "People")
group by person.file.name
I also tried working with a table, but after grouping, I couldn’t simultaneously keep information from “People” and “Journal.”