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.
サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
