topic Re: Change Definition Query of Multiple Layers with Python in Python Questions

Change Definition Query of Multiple Layers with Python

CraigLimbert — Wed, 15 Dec 2010 17:42:46 GMT

Can anyone help me with a python script that will change the definition query of two layers to the same thing. I have 2 layers that I want to change the definition query on at the same time to the same value(s).
ex) Layer1 Definition Query ---[pid] = 4
Layer2 Definition Query ---[pid] = 4

I want to be able to update both definition queries in one step using python.

Re: Change Definition Query of Multiple Layers with Python

ChrisMathers — Wed, 15 Dec 2010 17:48:06 GMT

Well you would create two layer objects with arcpy.mapping and then iterate over them changing the definition queries using the definitionQuery attribute of the layer.

Create_Layers
for layer in layers:
layer.definitionQuery='[pid] = 4'

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Layer/00s300000008000000/

Re: Change Definition Query of Multiple Layers with Python

DanielJohns — Sat, 11 Dec 2021 18:48:19 GMT

import arcpy
queryStr = "Hello World"
mxd = arcpy.mapping.MapDocument("CURRENT")

for lyr in arcpy.mapping.ListLayers(mxd):
  if lyr.supports("DEFINITIONQUERY"): 
  lyr.definitionQuery = queryStr

del mxd