nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to filter out features with WHERE clause

REDARiahi

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!

Finde mehr Beiträge mit dem Tag

Accepted answers

jcarlson

"Not equals" should be "<>".

All comments

jcarlson

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.

REDARiahi

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?

jcarlson

"Not equals" should be "<>".

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.