topic Re: How to filter out features with WHERE clause in ArcGIS JavaScript Maps SDK Questions

How to filter out features with WHERE clause

REDARiahi — Wed, 17 Nov 2021 19:27:26 GMT

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!

Re: How to filter out features with WHERE clause

jcarlson — Wed, 17 Nov 2021 19:36:38 GMT

"Not equals" should be "<>".

Re: How to filter out features with WHERE clause

REDARiahi — Wed, 17 Nov 2021 19:40:12 GMT

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?

Re: How to filter out features with WHERE clause

jcarlson — Wed, 17 Nov 2021 20:24:42 GMT

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.