topic Re: Using Python to set a definition query in ArcPro in Python Questions

Using Python to set a definition query in ArcPro

AmyRoust — Fri, 18 Jan 2019 20:43:51 GMT

I'm rewriting a Python 2.x script so that it can be used in Pro, and I'm stuck on setting a definition query for a layer. Here's what I tried in Pro's Python Window:

aprx = arcpy.mp.ArcGISProject("CURRENT")
m = aprx.listMaps("Map")[0]

for lyr in m.listLayers("Parcel"):
if lyr.supports("DEFINITIONQUERY"):
lyr.definitionQuery = 'JOINPIN = 201-02-0-00-00-012.01-0'

Then I thought maybe the definition query had to be written like a SQL statement, so I tried:

aprx = arcpy.mp.ArcGISProject("CURRENT")
m = aprx.listMaps("Map")[0]

for lyr in m.listLayers("Parcel"):
if lyr.supports("DEFINITIONQUERY"):
lyr.definitionQuery = 'Join Pin is Equal to 201-02-0-00-00-012.01-0'

Neither option generated an error message, but no definition query is set on the Parcel layer.

Appreciate any help I can get! Documentation for moving from 2.x to 3.x for ArcPro doesn't have a lot of code examples that I can copy.

Re: Using Python to set a definition query in ArcPro

BrittneyWhite1 — Fri, 18 Jan 2019 21:01:23 GMT

Two things to check:

1. Is your lyr.definitionQuery line indented below your if line? If not, make sure it is indented.

2. What's the data type for your JOINPIN field? If it is a string, the value needs be in single quotes. It may look something like: lyr.definitionQuery = "JOINPIN = '201-02-0-00-00-012.01-0'".

You can also check out the SQL syntax section in the help: Write a query in the query builder—ArcGIS Pro | ArcGIS Desktop

Re: Using Python to set a definition query in ArcPro

AmyRoust — Fri, 18 Jan 2019 21:19:55 GMT

My indents are good, and I tried the quotes like you have in your example (JOINPIN is a string). Still no luck. Other ideas?

Re: Using Python to set a definition query in ArcPro

DanPatterson_Retired — Fri, 18 Jan 2019 21:37:41 GMT

/blogs/dan_patterson/2016/08/14/script-formatting

Amy....

Based on your pasted code, the last line in both examples need to be indented after the if statement.

It probably looks good on your screen but...

Code formatting helps ensure proper indentation from application to geonet

Re: Using Python to set a definition query in ArcPro

AmyRoust — Sat, 11 Dec 2021 13:41:37 GMT

Good tip, thanks. Let's try this:

aprx = arcpy.mp.ArcGISProject("CURRENT")
m = aprx.listMaps("Map")[0]
for lyr in m.listLayers("Parcel"):
     if lyr.supports("DEFINITIONQUERY"):
     lyr.definitionQuery = "JOINPIN = '201-02-0-00-00-012.01-0'"‍‍‍‍‍

Re: Using Python to set a definition query in ArcPro

DarrenWiens2 — Fri, 18 Jan 2019 22:00:35 GMT

Have you tried adding print statements to ensure it's getting past the 'for' and 'if' how you expect? Also, check the lyr.definitionQuery before and after attempting to change.

Re: Using Python to set a definition query in ArcPro

AmyRoust — Sat, 11 Dec 2021 13:41:40 GMT

Of all things, it appears that I just needed an asterisk after my layer name to make it work:

aprx = arcpy.mp.ArcGISProject("CURRENT")
m = aprx.listMaps("agmap")[0]
for lyr in m.listLayers("Parcel*"):
    lyr.definitionQuery = "JOINPIN = '201-02-0-00-00-012.01-0'"‍‍‍‍

Re: Using Python to set a definition query in ArcPro

AmyRoust — Sat, 11 Dec 2021 13:41:44 GMT

So, I just upgraded to Pro 2.4.0 and the syntax that I originally marked as correct above is no longer working. This used to work:

aprx = arcpy.mp.ArcGISProject("CURRENT")
m = aprx.listMaps("agmap")[0]
for lyr in m.listLayers("Parcel*"):
    lyr.definitionQuery = "JOINPIN = '201-02-0-00-00-012.01-0'"‍‍‍‍‍‍‍‍

Anyone have any suggestions on what might have changed? Maybe it has to do with the fact that you can have multiple definition queries in Pro and only have one active?

Re: Using Python to set a definition query in ArcPro

PeterBandura — Thu, 01 Oct 2020 08:53:32 GMT

I do not know if it is still relevant, but I have version 2.5.2 and your code is working for me