Need to change a layer's definition query in two maps (main and inset) of a single layout.

Question

I've written a python script (arcpy) that takes the text from an email containing a ticket number and lat/long coordinates.  I've been able to extract the data containing the ticket number, lat/long coordinates that form a rectangle, and other data.  This data is a list that updates a featureclass in a file gdb.  I've also updated/changed the layout's name to reflect the ticket number.  The feature class/layer is used in both the main map and a reference or inset map.  The aprx has 2 maps, and one layout.

What I can't figure out is how to change the layer's definition query, so that I can zoom to or pan to the new feature.  I think I need to use the Cartographic Information Model (cim), but I'm not sure how to change the layer's definition query.

I'm working in ArcGIS Pro 2.9

Shauna-RaeBrown · Answer

I mostly figured it out!  However, it created another Query 1 with the correct definition query, and it added the definition query to both maps.  See my code below.

aprx = arcpy.mp.ArcGISProject("CURRENT")
ticketNo = "2023070700400.002"
fieldname = "tktNum"
newName = str.format(ticketNo)
for m in aprx.listMaps():
  for l in m.listLayers("AZ811 BlueStake"):
    if l.supports('DefinitionQuery'):
      #Get the list of definition queries
      dql = l.listDefinitionQueries('Query 1')
      #Clear active definition query, update will fail if there is already an active query
      for dq in dql:
        dq['isActive'] = False
      #Create a new definition query and append it to the list
      dql.append({'name': 'Query 1', 'sql': """{} = '{}'""".format(fieldname,newName), 'isActive': True})
      #Update the definition queries with the newly modified list
      l.updateDefinitionQueries(dql)

Now, I just need to figure out how to have just the one definition query on the layer.  Thanks for your help @DanPatterson !

DanPatterson · Answer

You changed it from a list to a string in line 10 so you can't cycle through it as you appear to want to do.

Their line is

dql = l.listDefinitionQueries()

Shauna-RaeBrown · Answer

@DanPatterson, Thanks for your help. I've been working on adapting example 4, but I keep getting an error. I think it has to do with the ticketNo = "2023070700400.002". That field in my feature class is a text field. I've tried tickeNo = str(2023070700400.002) and I get the same error. Of course it could have to do with my sql query. I'm stumped. Thanks for ANY help that you can offer. aprx = arcpy.mp.ArcGISProject("CURRENT") ticketNo = "2023070700400.002" m = aprx.listMaps()[0] l = m.listLayers("AZ811 BlueStake")[0] if l.supports('DefinitionQuery'): #Get the list of definition queries dql = l.listDefinitionQueries('Query 1')[0] #Clear active definition query, otherwise the update will fail if there is already an active query for dq in dql: dq['isActive'] = False #Create a new definition query and append it to the list dql.append({'name': 'Query 1', 'sql': "tktNum = ticketNo", 'isActive': True}) #Update the definition queries with the newly modified list l.updateDefinitionQueries(dql) Traceback (most recent call last): File "", line 10, in TypeError: 'str' object does not support item assignment