Hey all,
I'm trying to create a definition query for a points layer where I only was to display the points in the TYPE field of 1 and 2 and then leave type 3 hidden. Anyone know how to do this?
TYPE IN (1, 2)
Got it! Thanks!
The Syntax does depend on the input data type. Assuming it's a feature class, use https://pro.arcgis.com/en/pro-app/latest/help/mapping/navigation/write-a-query-in-the-query-builder.htm as an example.
For the interactive selection:
Type is equal to 1
OR
Type is equal to 2
for SQL syntax:
TYPE = 1 Or TYPE = 2
NB if the numbers are actually strings(text) then enclose '1' and '2' in quotes.
Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.