I'm trying to filter out features with Departamento = '01 - País' using the WHERE clause, using "!=", but it returns "Invalid Syntax". Here is the REST API url and this is the WHERE clause statement I'm using:
WHERE = FECHA>=CURRENT_TIMESTAMP - INTERVAL '10' DAY
AND Departamento != '01 - País'
The syntax is valid with "=", but not with "!=".
Thanks for the help!
Solved! Go to Solution.
"Not equals" should be "<>".
Thanks Josh, didn't think about that one! I was mislead by the documentation stating that "!=" was an accepted syntax. I'm I understanding it wrong?
I'd bet it's this sentence here:
Some data sources have restrictions on what is supported.
That's in reference to which SQL-92 commands are acceptable in the where parameter. I'd take a closer look at the data source you're querying and what kind of database it's running on, as that may be what's causing the issue.