Dataview Query, troublesome WHERE question

Things I have tried

TABLE
  type AS "Type",
  Lead AS "Project Lead",
  Status AS "Current Status",
  Priority AS "Priority"
  From -"Daily" AND -"Templates"
  WHERE Lead =  "Bianca"
SORT Priority desc
TABLE
  type AS "Type",
  Lead AS "Project Lead",
  Status AS "Current Status",
  Priority AS "Priority"
  From -"Daily" AND -"Templates"
  WHERE Lead contains "Bianca"
SORT Priority desc
TABLE
  type AS "Type",
  Lead AS "Project Lead",
  Status AS "Current Status",
  Priority AS "Priority"
  From -"Daily" AND -"Templates"
  WHERE Lead Includes "Bianca"
SORT Priority desc

What I’m trying to do

I have YAML which as “Lead” per file. However, I sometimes have more than one Lead.
I am trying to create tables on staff files which pulls from this YAML.
I can create a table no problem using the first statement. However I cannot get it to work on files where there is more than one “Lead”.
For reference on those other pages YAML looks like this (e.g.):
Lead: [Person1, Person2, Bianca]
( I have also tried Lead: Person1, Person2, Bianca with no square brackets.

I would love to get this working. I think its simple but I am just getting started with Obsidian and Dataview…
Thanks!

WHERE contains(Lead, "Bianca")

https://blacksmithgu.github.io/obsidian-dataview/query/functions/#containsobjectliststring-value

1 Like

Thanks @joethei ! I knew it was simple. Just getting the syntax right.
MUCH appreciated!

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