SQL filtering for Nodes: External field not working

Question

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

HolyGuacamole · Accepted Answer

External happens to be a SQL keyword as well

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

Top Replies