cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 10

SQL filtering for Nodes: External field not working

Jump to solution

I'm trying to filtering nodes in All Nodes - Tree (AJAX) window with following statuses;

Node is not UP and Node is not External.

So, SQL Filter should be:

Status<>1 AND External<>1

With those settings, I get error message:

Bad filter '(Status<>1 AND External<>1)' specified. Incorrect syntax near the keyword 'External'

It seems that External field is not accepted to filter, but it's listed in Node Properties

0 Kudos
1 Solution
Level 17

External happens to be a SQL keyword as well

Reserved Keywords (Transact-SQL)

and when it is a column name it will need to be escaped. try wrapping [ ] around the word External and it should work fine.

Status<>1 AND [External]<>1

View solution in original post

4 Replies
Level 10

Thanks, that worked!

0 Kudos
Level 13

Hello,

use [external] <> 1

External is some SQL keyword.

thanks

Lada

0 Kudos
Level 17

External happens to be a SQL keyword as well

Reserved Keywords (Transact-SQL)

and when it is a column name it will need to be escaped. try wrapping [ ] around the word External and it should work fine.

Status<>1 AND [External]<>1

View solution in original post

Youre faster]]

0 Kudos