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

Simple question

KarenSnitzer

New student here...

I am trying to select by attributes, but when I put in the query, no records are selected. I looked at one record in the table and there are multiple features under the tree. Can this be causing the problem? And how can I get around it?

Thanks.

Find more posts tagged with

Accepted answers

StevenGraf1

You could write your query as such also:

"LANDCODE" IN ('941', '980', '910', '940', '930', '734')

Here is a SQL Query Reference Guide.

Steven

All comments

KarenSnitzer

Thanks!! I'll try both methods!

Karen

StevenGraf1

You could write your query as such also:

"LANDCODE" IN ('941', '980', '910', '940', '930', '734')

Here is a SQL Query Reference Guide.

Steven

TimWitt2

Karen,

instead of AND use OR. When you use AND it looks for a row that has all of the LANDCODE you specify in it.

With OR it selects each number.

Tim

KarenSnitzer

When I selected each row manually from the attribute table and made it into a layer it worked.

Here is how I did the query tho for those attributes:

LANDCODE = '941' AND LANDCODE = '980' AND LANDCODE = '910' AND LANDCODE = '940' AND LANDCODE = '930' AND LANDCODE = '734'

I don't understand why it wouldn't do the same thing as selecting each row manually, tho. Can you explain?

Thanks!

TimWitt2

Hi Karen,

Can you post your query here?

Tim

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.