More complex "filter nodes" for views?

FLTPK

So I've got a few users who only need to see down nodes in certain sections of our enterprise.  In order to save screen retail I was trying to put this in to one single column and a single view resource, but I cannot seem to get the SQL queries to work the way I want.  I admit that I have no experience with SQL queries at all, and have only the knowledge that I've figured out with this, so that's probably why I primarily need help.  Here's my query:

 

UnManaged<>1 AND Caption Like '528*' OR Caption Like '091*' OR Caption Like '417*'

 

Basically what I'm trying to achieve here is to show nodes that are managed, and are located in either of those categories listed.  When I just do the following it works exactly the way I want it to, albeit without any additional categories that I need:

 

UnManaged<>1 AND Caption Like '528*'

 

Thanks for the help in advance!

qle

See if wrapping parentheses around your OR grouping helps so that it looks like this:

UnManaged<>1 AND (Caption Like '528*' OR Caption Like '091*' OR Caption Like '417*' )