topic Re: SQL Query in labeling in ArcGIS Explorer Desktop Questions

SQL Query in labeling

ELTerrell — Thu, 20 Mar 2014 11:35:34 GMT

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?

Re: SQL Query in labeling

ELTerrell — Thu, 20 Mar 2014 11:51:28 GMT

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.

Re: SQL Query in labeling

MichaelVolz — Thu, 20 Mar 2014 12:09:22 GMT

How about OR instead of AND?

Re: SQL Query in labeling

ELTerrell — Thu, 20 Mar 2014 13:33:53 GMT

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?

Re: SQL Query in labeling

MichaelVolz — Thu, 20 Mar 2014 13:55:07 GMT

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')

Re: SQL Query in labeling

ELTerrell — Thu, 20 Mar 2014 14:28:24 GMT

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

Re: SQL Query in labeling

BenVan_Kesteren1 — Wed, 02 Apr 2014 23:36:08 GMT

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

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

Re: SQL Query in labeling

ELTerrell — Thu, 03 Apr 2014 11:32:40 GMT

Thanks Ben! I'll try that next.

Re: SQL Query in labeling

EllenBryson2 — Tue, 20 Jan 2015 21:57:25 GMT

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.