Filter Nodes (SQL)

Question

Dear Community,

I want to be able to see two custom propierties in a single Filter Nodes (SQL) I'm putting the following;

Owner = 'servers*' AND Owner = 'routers'

What I'm doing wrong??

Is it the SQL Statement?????

Thank you for you time.

njoylif · Answer

depending on what you are trying to get will depend on whether its an AND/OR.
Since you are checking against the same field, it should most likely be an OR.  If you do an AND on the same field, you'll not get anything back because it only holds one value.
SELECT * FROM Nodes WHERE Owner='servers%' OR Owner='routers'

sedmo · Answer

I think your filter needs to look like this.

Owner like 'servers*' or Owner = 'routers'