SQL Filter to show particular nodes

I am trying to show nodes that are doing a particular task, I have got the list I require except for two more nodes which have 'symp' in their name (caption) can anyone suggest the syntax for adding to the filter I am already using below,

Caption like '*nice*' AND Environments = 'Incidents & Operations' AND Category = 'Call Logging'

I have tried simply putting an OR in after the '*nice*' but I assume I am not using the correct syntax.

Any help would be appreciated, thanks.

Find more posts tagged with

Accepted answers

sedmo

How about something like this?

(Caption like '*nice*' AND Environments = 'Incidents & Operations' AND Category = 'Call Logging') or Caption like '*symp*'

All comments

sedmo

How about something like this?

(Caption like '*nice*' AND Environments = 'Incidents & Operations' AND Category = 'Call Logging') or Caption like '*symp*'

kreases

Thanks, that works fine, do you know if there is anywhere I can find any information on the various filters we can use and their syntax as the help is very limited.

sedmo

I'm not aware of any documentation beyond what is on the page where you edit the filter. You're basically entering syntax for the where clause in an SQL query so documentation regarding SQL queries would probably be your best source of information. I noticed they include this statement on the edit filter page.

This is an advanced feature. We recommend you have a basic understanding of SQL Queries.