Add a definition query to a layer in multiple mxd's

Question

i hope someone can help - I have an number of mxd's in a folder each with the same layers in but a different spatial extent.
I'd like to write a script that applies the definition query to the layer in each of these MXD's - can someone help?

ClaireParsons1 · Answer

Hi guys

Thanks for your replies and help.  This is the code I have used.import arcpy, glob, os

path = r"C:\Users\Documents\GIS\Drawings\Revisions 06042012"

mxdList = glob.glob(path + "\*.mxd")

for mxd in mxdList:
    mxd = arcpy.mapping.MapDocument(mxd)
    print mxd
    layers = arcpy.mapping.ListLayers(mxd,"Local Wildlife Sites")
    print layers
    for layer in layers:
        defquery = '"LWS_STATUS"' + " = 'pLWS'"
        print defquery
        layer.definitionQuery = defquery
        mxd.save()

MarcinGasior · Answer

To change Definition Query in multiple MXD's try the following code:import arcpy, os
workspace = r"C:	mp\MapProjects"
try:
    for filename in os.listdir(workspace):
        fullPath = os.path.join(workspace,filename)
        if os.path.isfile(fullPath):
            basename, extension = os.path.splitext(fullPath)
            if extension.lower() == '.mxd':
                mxd = arcpy.mapping.MapDocument(fullPath)

#here build your definition query as STRING eg.:
                defQuery = '"OBJECTID" < 100'
                #Replace YourLayerName with the layer name (String) which will be changed
                for myLayer in arcpy.mapping.ListLayers(mxd, 'YourLayerName'):
                    myLayer.definitionQuery = defQuery
                mxd.save()
except:
    arcpy.GetMessages()
del mxd, myLayer

achapapkowski · Answer

You can use the mapping module to write a query definition to the layer.

Example:
from arcpy import mapping
import arcpy

mxd = mapping.MapDocument("CURRENT")
layers = mapping.ListLayers(mxd)
for layer in layers:
   layer.definitionQuery = "<FIELD> = '" + sql + "'"
   del layer
mxd.save()
del layers
del mxd

Hope this helps.