Hi there, you can definitely do this, subfolders and all. No file moving necessary. Here is the skeleton of the code you will need:import os, arcpy #here's an example of how to run through all the layers in an mxd def SetDefQueries(mxdobject, defquery): fixed_layers = [] for layer in arcpy.mapping.ListLayers(mxdobject): #this should weed out the group layers and rasters if layer.supports("DEFINTIONQUERY"): fixed_layers.append(layer.name) layer.definitionQuery = defquery #have the function return a list summary of the layers that were changed (for fun) return fixed_layers #create and print query query = '"VALIDATIONSTATE" = 3' #may have to fix the syntax of this statement depending on the field type arcpy.AddMessage(query) #to go through all of the folder, use os.walk(), you can find documentation on the python website for path, dirs, files in os.walk(top/folder/path): for f in files: if f.endswith(".mxd"): #this should get you all of the mxds in all of the folders. mxd_path = path + "\\" + f arcpy.AddMessage(mxd_path) #now you can make arcpy.mapping.MapDocument() objects mxd = arcpy.mapping.MapDocumentmxd_path) #use the SetDefQuery function on the mxd changed_layers = SetDefQuery(mxd, query) #print a summary of what happened arcpy.AddMessage("In {}:".format(mxd_path)) lyrs_summary = "\n ".join(changed_layers) arcpy.AddMessage(lyrs_summary) #save the mxd at the end (won't work if you have it open) mxd.save()
You may need to do a little bit of trouble shooting, but this should serve as a good basis for what you need in the end. You could run it straight from a .py file on the desktop if you just change the arcpy.AddMessage() pieces to normal print statements. Also, this is from my experience in 10.0, but I'm fairly certain that these things work the same way in 10.x
