nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

SQL Syntax

Nhicks

I am grouping my nodes by the comment section.

I currently have a column for each set of equipment. My syntax in those filters work fine;

Comments <> 'AMI_Metro' (for column 1)

Comments <> 'AMI_Macro' (column 2)

I'm trying to create a third column that would be for all equipment EXCEPT the two above. How do I create an OR statement in the SQL filter line?

I've tried the following:

Comments <> 'AMI%'

Comments <> 'AMI_Metro' OR 'AMI_Macro'

Comments <> 'AMI_Metro' OR Comments <> 'AMI_Macro'

They either dont filter it, or return a syntax error. Can anyone assist with an OR statement?

Thanks

Nhicks

Find more posts tagged with

Accepted answers

mharvey

You need to encapsulate what you are trying to capture. If you want anything but the two values, you'd actually want an AND not an OR.

(Comments NOT LIKE 'AMI_Metro') AND (Comments NOT LIKE 'AMI_Macro') should get you what you are looking for.

Regards,

Matthew Harvey

Loop1 Systems

http://www.loop1systems.com

All comments

mharvey

You need to encapsulate what you are trying to capture. If you want anything but the two values, you'd actually want an AND not an OR.

(Comments NOT LIKE 'AMI_Metro') AND (Comments NOT LIKE 'AMI_Macro') should get you what you are looking for.

Regards,

Matthew Harvey

Loop1 Systems

http://www.loop1systems.com

Nhicks

That did it… I appreciate it, VERY much! I'm not an IT guy, more field work, but glad to have your assistance!

If I knew about your company we might have had you guys set it up initially instead!

Neil M Hicks

Telecom Technician

608-289-1183

mharvey

Neil,

Always a pleasure. Glad to offer what assistance I could. If you guys end up with any other SW software, don't hesitate to contact us for deployment/training assistance.

Regards,

Matthew Harvey

Nhicks

I have a new problem now. The string mharvery gave works fine.

The filter is working, however, the Tree list isnt showing my DOWN nodes, unless they have something in the comments field. I have one node with a circuit id in the comment section, its showing "Down" as it should. I have another node with a blank comment section, that wont show up at all in the down nodes tree list. These are not part of the filters above, so they SHOULD both display.

Short of putting something in EVERY comment field for every node, is there a way around this?

mharvey

The reason you are seeing this is because within the database these empty fields are actually NULL values that are basically ignored by the filter, meaning they won't apply to the filters you want unless you add the following:

Comments is NULL. You may want to add this to the existing filter so:

(Comments NOT LIKE 'AMI_Metro') AND (Comments NOT LIKE 'AMI_Macro') OR (COMMENT IS NULL). Here you'd put in the OR to make sure that your other devices you are seeing are still being listed.

regards,

Matthew Harvey

Nhicks

Once again thank you SO much! It works flawlessly.

I am learning more and more about SQL than I ever wanted to, but its good stuff!

Neil M Hicks

Telecom Technician

608-289-1183

Nhicks

mharvey, can you ping me offline? neilhicks@alliantenergy.com