topic Re: What should I change to run this python script on the specific layers only (not all the layers in the MXD) , or just some layers in a group ? in ArcMap Questions

What should I change to run this python script on the specific layers only (not all the layers in the MXD) , or just some layers in a group ?

MAMDOUHZALAKY — Sun, 17 Sep 2023 19:09:44 GMT

import arcpy

mxd = arcpy.mapping.MapDocument("CURRENT")

for lyr in arcpy.mapping.ListLayers(mxd):

if lyr.supports("DEFINITIONQUERY"):

lyr.definitionQuery = "INSERT_YOUR_DQ_HERE"

Re: What should I change to run this python script on the specific layers only (not all the layers in the MXD) , or just some layers in a group ?

JeffHouser — Mon, 18 Sep 2023 04:00:51 GMT

For example, maybe try the following:

For file geodatabase (gdb) or shapefile:
lyr.definitionQuery = '"Docket"' + " = " + "'1254-2017'"
or for personal gdb
lyr.definitionQuery = '[Docket]' + " = " + "'1254-2017'"

-Jeff

Re: What should I change to run this python script on the specific layers only (not all the layers in the MXD) , or just some layers in a group ?

MAMDOUHZALAKY — Mon, 18 Sep 2023 06:49:35 GMT

Can you explain to me with more details .... what should i replace in my python script to do what i want ? I do not understand Docket"' + " = " + "'1254-2017'" !!

Re: What should I change to run this python script on the specific layers only (not all the layers in the MXD) , or just some layers in a group ?

JohannesLindner — Mon, 18 Sep 2023 11:20:55 GMT

To insert formatted code:

If your definition query is the same for all specified layers:

layer_names = ["Layer A", "Layer B", "Layer E"] mxd = arcpy.mapping.MapDocument("CURRENT") for lyr in arcpy.mapping.ListLayers(mxd): if lyr.name in layer_names and lyr.supports("DEFINITIONQUERY"): lyr.definitionQuery = "INSERT_YOUR_DQ_HERE"

If you want different queries for the layers:

queries = { "Layer A": "Query for Layer A", "Layer B": "Query for Layer B", "Layer E": "Query for Layer E", } mxd = arcpy.mapping.MapDocument("CURRENT") for lyr in arcpy.mapping.ListLayers(mxd): if lyr.name in queries and lyr.supports("DEFINITIONQUERY"): lyr.definitionQuery = queries[lyr.name]

Re: What should I change to run this python script on the specific layers only (not all the layers in the MXD) , or just some layers in a group ?

JeffHouser — Mon, 18 Sep 2023 13:26:06 GMT

Docket = field in the layers attribute file.

'1254-2017' = is a specific txt value.

Please also refer to JL's post... Great info

-Jeff