topic Re: Add a definition query to a layer in multiple mxd's in Python Questions

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

ClaireParsons — Mon, 16 Apr 2012 10:44:13 GMT

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?

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

AndrewChapkowski — Sat, 11 Dec 2021 06:50:21 GMT

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.

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

MarcinGasior — Sat, 11 Dec 2021 06:50:24 GMT

To change Definition Query in multiple MXD's try the following code:

import arcpy, os
workspace = r"C:\tmp\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

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

ClaireParsons1 — Sat, 11 Dec 2021 06:50:27 GMT

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()