And/Or in Filters (Database Editor)

Use the Or operator to start a new rule. For example, say your filter looks like the following window:

Database Editor processes the filter as shown in the following table:

Using filters in Database Editor

And/Or	Field Name	Test	Value
	Description	Contains	Blue
Or	Description	Contains	Metal and Red
Or	Description	Contains	Wood and Green

The following table shows how this filter treats sample data:

Example of filters you can use in Database Editor

Description	Passes Test?	Why
Blue Green Red	Yes	Contains Blue
Green	No	Does not contain (Wood and Green)
Green Metal	No	Does not contain (Wood and Green) or (Metal and Red)
Blue Green Red	Yes	Contains Blue
Red Wood	No	Does not contain (Wood and Green) or (Metal and Red)
Red Metal	Yes	Contains (Metal and Red)