Query in dataview that uses an "or" parameter

[cl22]

First, search the help docs and this forum. Maybe your question has been answered! The debugging steps can help, too. Still stuck? Delete this line and proceed.

What I’m trying to do

I’m trying to create a table that shows results that have one property value OR another.

My use case is that I have blogs that I’m researching, writing, or editing. I have a property called “Area” and I use the value “Blog”. I also have a property called “Next Action” and that is where I put one of the action values.

I want a table that shows me all blogs that are EITHER “writing” OR “editing”. I can show one, but I can’t figure out how to show both.

This is a view that works:

TABLE next-action as “Next Action”
WHERE contains(next-action,“Write”) AND contains(area,“Blog”)

But of course that does not include anything with an “edit” value and I can’t get it to work for both.

Things I have tried

I tried searching for the answer but I’m not sure how to phrase the request effectively and have not been able to turn anything up. Any thoughts are much appreciated, thank you.

[anon23099027]

Something along these lines?

# Q1 - find all the Blog articles

```dataview
TABLE NextAction as "Next Action"
WHERE Area = "Blog"
SORT file.name ASC
```

# Q2 – find the Blog articles that are either Writing or Editing 

```dataview
TABLE NextAction as "Next Action"
WHERE Area = "Blog" 
AND contains(NextAction, "Writing") 
OR contains(NextAction, "Editing")
SORT file.name ASC
```

[holroy]

Your second suggestion, @anon23099027 , could be misunderstood as you don’t group the OR clauses together. To ensure a proper match I’d using something like:

```dataview
TABLE NextAction as "Next Action"
WHERE Area = "Blog" 
  AND (contains(NextAction, "Writing") OR contains(NextAction, "Editing"))
SORT file.name ASC
```

Now we’re making certain that all results are actually from the blog area, and either of the actions Writing or Editing.