this post was submitted on 17 Jun 2023
12 points (100.0% liked)

ObsidianMD

4118 readers
10 users here now

Unofficial Lemmy community for https://obsidian.md

founded 1 year ago
MODERATORS
grabyourmotherskeys
Pexily
12
How to use Dataview for notes that contain multiple values for a single field? (self.obsidianmd)
submitted 1 year ago by ReclusiveExtrovert to c/obsidianmd
9 comments fedilink hide all child comments
 

I have a number of individual notes for various books I've read, with a YAML field for "author." This works great with Dataview, except when there are multiple authors of a book. I assumed I could just add another YAML line "author: Sample Author" to add the second author, but then Dataview does not return results for either author.

Does anyone know how to change my query so it will return results for either author? Is this possible?

My current search is:

dataview TABLE without ID link(file.link, title) as "Title", author FROM #books Where author = "Sample Author"

you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 2 points 1 year ago (1 children)

Do the variables in the single-line array need square brackets?

[–] [email protected] 3 points 1 year ago (2 children)

my understanding is that’s a required part of the YAML syntax, yes

[–] [email protected] 3 points 1 year ago (1 children)

Sorry. I just looked through the Dataview documentation and found that my inline data needed double-quote marks rather than brackets. Like this:

Writer:: "John Byrne", "Mike Mignola"

It works now and solves an issue I was having. Thank you.

[–] [email protected] 1 points 1 year ago

ah yeah, I haven't used Dataview's inline data before. Glad you figured it out! :)

[–] [email protected] 1 points 1 year ago

Thanks.

I tried it out and if it's placed in the front-matter at the top of the note like this it works:

Writer: [John Byrne, Mike Mignola]

Unfortunately, most of my data is in the body of the notes using double-colon syntax like this - and it doesn't get picked up by the Dataview query:

Writer:: [John Byrne, Mike Mignola]

Am I missing something?