Hello! I have a three types of entities - notes, books and authors
In each note, I add metadata, which connect this note with book.
And in each book I add metadata which connect this book from author.
I can use query in author:
‘’’
list from “Entities/content/books” where Autor=[[Brian Tracy]]
‘’’
and I will see all books from this author.
But I want to see all notes from this author. Can I build subquery in dataview(by analogy with JOIN from Mysql)?
Thanks.
mnvwvnm
2
I’m not a coder, so I don’t understand the meaning of “JOIN from Mysql”.
But trying to understand what you want:
- In your notes you have a field connecting to your books (e.g.
book: "[[Book1]]"
)
- In your book note you have a field connecting the author (e.g.
author: "[[Author_A]]"
)
- You want a query to call all notes indirectly related with the author (via “books”)
Because all your fields are links, you can try this (considering the fields in my examples):
```dataview
LIST
WHERE book.author = [[Author_A]]
```
This means: "where the field author
in the note linked by the field book
is equal to [[Author_A]]
"
https://blacksmithgu.github.io/obsidian-dataview/query/expressions/#links
Oh yeah! You got it absolutely right and your code works. Thank you very much
system
Closed
4
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.