#1

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.

#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

#3

Oh yeah! You got it absolutely right and your code works. Thank you very much

#4

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.