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; } } }

SQL Query in labeling

ELTerrell

Hi all,

I have 10 cities within a county and I'm trying to label 9 of them. I thought an SQL query in the label feature would eliminate the one I didn't want labeled. I thought it should look something like this "Name" = 'New York' AND 'Los Angeles' and just leave out the one I don't want?

Find more posts tagged with

Accepted answers

mvolz47

Does ArcGIS Explorer Desktop have classes for labels like ArcMap does? If so, you can add a SQL Query there, that should allow either the syntax:

"Name" = 'New York' OR "Name" = 'Los Angeles'

or

"Name" in ('New York', 'Los Angeles')

All comments

EllenBryson2

Michael made a great suggestion with the IN function.

If you're wondering how to fix your original query, here's the solution.

"Name" = 'New York' OR "Name" = 'Los Angeles'

You need to mention the field name twice. And in this context I think the OR is what you want.

ELTerrell

Thanks Ben! I'll try that next.

BenVan_Kesteren1

"Name" in ('New York', 'Los Angeles')

This is the SQL I use often as sometimes the list can get quite long, and writing "Name" = xyz OR "Name" = xyz OR... over and over gets tedious 😄

ELTerrell

That worked...I just needed the second 'Name' instead of Name = New York OR Los Angeles.

mvolz47

ELTerrell

I tried that, I still get an error message. I also tried IS. I can only think that maybe it has something to do with the quotations?

mvolz47

How about OR instead of AND?

ELTerrell

So I found a solution although it wasn't the one I anticipated. I "added label classes from symbology categories" after having deleted the one city from symbology.

However, I'm thinking there has to be a way to label those using SQL query.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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