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

Turn off a selected Label in SQL Query ?

progis99

Hello ,

I am working on this Damn it Highways layer and I need to selected some labels for some of the highways. One of them I need to "turn it off" but it would not let me to.

I have this map that I am working on and is for to put on the webpage later.

That label I-25 I drew the red circle the lower right bottom of the map in Southwestern Kansas I need that to turn off but leave the road on. It would not turn it off.

Why doesn't my SQL query not working ?

Trouver plus de publications taguées avec

Accepted answers

All comments

progis99

It is not the value it is the Feature Identifier that I want to turn it off ...

progis99

Not sure what you mean ?

AbdullahAnter

Are you sure that you have this values in the field?

could you identify the road before create the SQL expression to know what the value you need ?

progis99

I tried to put parentheses on the first expression before the OR and didn't work so my expression wasn't right. So, that is why I move the FID <> 321 at the beginning of the expression and then insert the HWY_SYMBOL = 25 or HWY_SYMBOL = 70. after the AND.

DarrenWiens2

I suspect it's just a matter of how the SQL interprets the grouping of your terms, which is why you should always force your grouping with parentheses. I suspect in your original attempt ("HWY_SYMBOL" = '25' OR "HWY_SYMBOL" = '70' AND "FID" <> 321), it was interpreted as:

<SPAN class="string token">"HWY_SYMBOL"</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'25'</SPAN> <SPAN class="operator token">OR</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"HWY_SYMBOL"</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'70'</SPAN> <SPAN class="operator token">AND</SPAN> <SPAN class="string token">"FID"</SPAN> <SPAN class="operator token"><></SPAN> <SPAN class="number token">321</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Since FID=321 is HWY_SYMBOL='25', all labels will show.

I think you could change your original to the following:

<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"HWY_SYMBOL"</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'25'</SPAN> <SPAN class="operator token">OR</SPAN> <SPAN class="string token">"HWY_SYMBOL"</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'70'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">AND</SPAN> <SPAN class="string token">"FID"</SPAN> <SPAN class="operator token"><></SPAN> <SPAN class="number token">321</SPAN>‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

This will first filter the HWY_SYMBOL to either '25' or '70', and from those, remove FID=321.

progis99

After I posted it here, I played it around a little bit and decide to flipped the expression like this:

"FID" <> 321 AND "HWY_SYMBOL" = '25' OR "HWY_SYMBOL" = '70'

that worked ! That I-25 Label now disappear !

DarrenWiens2

I take it that feature you want to remove the label from is "FID" = 321?

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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