Select to view content in your preferred language

Creating "IN" Definition Query

265
2
03-05-2024 09:08 AM
RobertCox87
New Contributor II

I am making the transition from ArcGIS Desktop to Pro, but I'm having trouble with definition queries.  I am currently working with a list of geographies and I want to write a query to only show certain polygons.  In Desktop, I would type something like Name in ('Example1', 'Example2', 'Example3') using the "Get Unique Values" button.  In Pro, it looks like I would have to create a multipart definition query using "or" for each clause I add.  Is there a way to create these similar to the desktop version where it gives me a list of unique values that I can create a list from?

0 Kudos
2 Replies
BarryNorthey
Occasional Contributor III

In Clause mode, use includes the value(s) and then pick from the list.

BarryNorthey_5-1709661310858.png

This generates the query using IN which you can see when you toggle on SQL mode:

BarryNorthey_3-1709661195658.png

 

 

 

 

Bud
by
Honored Contributor

There is also a toggle to switch to SQL mode. So you could write Name in ('Example1', 'Example2', 'Example3') from scratch if you want to.