topic Re: Creating "IN" Definition Query in ArcGIS Pro Questions

Creating "IN" Definition Query

RobertCox87 — Tue, 05 Mar 2024 17:08:45 GMT

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?

Re: Creating "IN" Definition Query

BarryNorthey — Tue, 05 Mar 2024 17:56:02 GMT

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

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

Re: Creating "IN" Definition Query

Bud — Thu, 07 Mar 2024 12:36:13 GMT

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.