topic SQL with one layer that has more than 2 conditions won't show a label to show up Question ? in ArcGIS Pro Questions

SQL with one layer that has more than 2 conditions won't show a label to show up Question ?

DEAF_PROBERT_68 — Sat, 28 Oct 2023 17:51:26 GMT

Hello,

I have been working on creating a state map with our forest. This is to show our customer who comes into our office and our front Desk employees can show them where or which forest. The map I have has a layer that show all the county names and their symbol too. I was able to turn two of them off :however, one of them will not allow me to turn it off . I had to create a new label class for that county because it will not display in the map layout.

Example in the Map Layout :

This circle shows the county label is missing and It is shown in hidden outside of the map t. It is located in Cheyenne, Nebraska. When I create a new label class for that Cheyenne, NE and it will show up correctly in the map layout.

However, the default label class I wrote will not allow me to turn Cheyenne label off . It keeps showing up and display.

( OR)

The list I create for Label classes as follows :

Would anyone in here help me out how to get it the label "Cheyenne" to turn it off in this Default label class ?

I believe this SQL requires me to have two conditons for one layer ; but what if you have at least two and I think it will not work for this situtation.

Re: SQL with one layer that has more than 2 conditions won't show a label to show up Question ?

DEAF_PROBERT_68 — Mon, 30 Oct 2023 16:02:32 GMT

Problem solved. I could not figure it out until this morning and decided to try different methods ; however this is the only way it works..

Re: SQL with one layer that has more than 2 conditions won't show a label to show up Question ?

Robert_LeClair — Mon, 30 Oct 2023 16:37:22 GMT

So if the goal is to not display Cheyenne County labels, this would work. I think the issue is parentheses and the use of and/or's. See below.

Re: SQL with one layer that has more than 2 conditions won't show a label to show up Question ?

DEAF_PROBERT_68 — Mon, 30 Oct 2023 16:48:05 GMT

Thank you !