I am trying to find a specific field name in layers in a current working MXD, but I'm having problems getting it right. The overall goal is to loop through layers in an MXD and set a definition query based on a user input (string type). The script runs without any errors, but no definition query is set. Could it be because the type returned by the arcpy.Describe().fields function is Unicode? Any help or advice is greatly appreciated! import arcpy #User input as 'String' type feederID = arcpy . GetParameterAsText ( 0 ) #Variables mxd = arcpy . mapping . MapDocument ( "CURRENT" ) df = arcpy . mapping . ListDataFrames ( mxd ) [ 0 ] #Set definition query to user set parameters for lyr in arcpy . mapping . ListLayers ( mxd , "" , df ) : fields = arcpy . Describe ( lyr ) . fields for f in fields : if f . Name == "FEEDERID" : lyr . definitionQuery = """FEEDERID = """ + "'" + str ( feederID ) + "'" arcpy . RefreshActiveView ( )

I'd try: #Set definition query to user set parameters for lyr in arcpy . mapping . ListLayers ( mxd , "" , df ) : if lyr.isFeatureLayer: # = arcpy . Describe ( lyr ) . fields for f in fields : if f . Name == "FEEDERID" : lyr . definitionQuery = """FEEDERID = """ + "'" + str ( feederID ) + "'"

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Find Specific Field Name in MXD Layers

MitchHolley1

I am trying to find a specific field name in layers in a current working MXD, but I'm having problems getting it right. The overall goal is to loop through layers in an MXD and set a definition query based on a user input (string type). The script runs without any errors, but no definition query is set.

Could it be because the type returned by the arcpy.Describe().fields function is Unicode?

Any help or advice is greatly appreciated!

<SPAN class="keyword token">import</SPAN> arcpy

<SPAN class="comment token">#User input as 'String' type</SPAN>
feederID <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#Variables</SPAN>
mxd <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>MapDocument<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"CURRENT"</SPAN><SPAN class="punctuation token">)</SPAN>
df <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ListDataFrames<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>


<SPAN class="comment token">#Set definition query to user set parameters</SPAN>
<SPAN class="keyword token">for</SPAN> lyr <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ListLayers<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> df<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; fields <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>lyr<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>fields
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> f <SPAN class="keyword token">in</SPAN> fields<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> f<SPAN class="punctuation token">.</SPAN>Name <SPAN class="operator token">==</SPAN> <SPAN class="string token">"FEEDERID"</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lyr<SPAN class="punctuation token">.</SPAN>definitionQuery <SPAN class="operator token">=</SPAN> <SPAN class="string token">"""FEEDERID = """</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"'"</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>feederID<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"'"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
arcpy<SPAN class="punctuation token">.</SPAN>RefreshActiveView<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Find more posts tagged with

Accepted answers

MicahBabinski

I'd try:

<SPAN class="" style="color: slategray; border: 0px; font-weight: inherit;">#Set definition query to user set parameters</SPAN>
<SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">for</SPAN> lyr <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">in</SPAN> arcpy<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>mapping<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>ListLayers<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN>mxd<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">,</SPAN> <SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;">""</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">,</SPAN> df<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">)</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">:
</SPAN>&nbsp;&nbsp;&nbsp; if lyr.isFeatureLayer: #<---this bit will ensure you are trying to access the fields of only feature layers
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fields <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit;">=</SPAN> arcpy<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>Describe<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN>lyr<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">)</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>fields
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">for</SPAN> f <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">in</SPAN> fields<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">if</SPAN> f<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>Name <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit;">==</SPAN> <SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;">"FEEDERID"</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lyr<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>definitionQuery <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit;">=</SPAN> <SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;">"""FEEDERID = """</SPAN> <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit;">+</SPAN> <SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;">"'"</SPAN> <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit;">+</SPAN> str<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN>feederID<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">)</SPAN> <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit;">+</SPAN> <SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;">"'"</SPAN>

All comments

DanPatterson_Retired

No multiple correct... so your options are to

'Helpful' all those that contributed
pick one as the most helpful either singularly, or cumulatively
mark it as 'assumed answered' if you can't pick one

MitchHolley1

All,

I finally got the script to successfully run thanks to all the kind people in this community. Below is the final code.

Dan Patterson‌ is there a way to mark several people's replies as the correct answer? This seems like it was a team effort since everyone contributed to the overall answer.

<SPAN class="keyword token">import</SPAN> arcpy

<SPAN class="comment token">#Get input from user</SPAN>
feederID <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN>
ischecked <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#Variables</SPAN>
mxd <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>MapDocument<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"CURRENT"</SPAN><SPAN class="punctuation token">)</SPAN>
field <SPAN class="operator token">=</SPAN> <SPAN class="string token">"FEEDERID"</SPAN>

<SPAN class="keyword token">for</SPAN> lyr <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ListLayers<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> lyr<SPAN class="punctuation token">.</SPAN>isFeatureLayer<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fields <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>lyr<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>fields
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> f <SPAN class="keyword token">in</SPAN> fields<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> f<SPAN class="punctuation token">.</SPAN>Name <SPAN class="operator token">==</SPAN> field<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; delim <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>AddFieldDelimiters<SPAN class="punctuation token">(</SPAN>lyr<SPAN class="punctuation token">,</SPAN>field<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lyr<SPAN class="punctuation token">.</SPAN>definitionQuery <SPAN class="operator token">=</SPAN> delim <SPAN class="operator token">+</SPAN> <SPAN class="string token">"='"</SPAN> <SPAN class="operator token">+</SPAN> feederID <SPAN class="operator token">+</SPAN> <SPAN class="string token">"'"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
<SPAN class="comment token">#Clear definition query&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>
<SPAN class="keyword token">if</SPAN> ischecked <SPAN class="operator token">==</SPAN> <SPAN class="string token">'true'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> lyr <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ListLayers<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> lyr<SPAN class="punctuation token">.</SPAN>isFeatureLayer<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lyr<SPAN class="punctuation token">.</SPAN>definitionQuery <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
arcpy<SPAN class="punctuation token">.</SPAN>RefreshActiveView<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

MitchHolley1

Josh,

Thank you for the time and the response. The layers are multiple map layers in a feature dataset residing in an enterprise geodatabase.

MitchHolley1

Micah,

Thank you very much for the response, but now I'm getting a different error.

Could this be because the layers I'm trying to set a definition query for are in a feature dataset?

MicahBabinski

I'd try:

<SPAN class="" style="color: slategray; border: 0px; font-weight: inherit;">#Set definition query to user set parameters</SPAN>
<SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">for</SPAN> lyr <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">in</SPAN> arcpy<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>mapping<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>ListLayers<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN>mxd<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">,</SPAN> <SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;">""</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">,</SPAN> df<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">)</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">:
</SPAN>&nbsp;&nbsp;&nbsp; if lyr.isFeatureLayer: #<---this bit will ensure you are trying to access the fields of only feature layers
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fields <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit;">=</SPAN> arcpy<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>Describe<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN>lyr<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">)</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>fields
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">for</SPAN> f <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">in</SPAN> fields<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">if</SPAN> f<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>Name <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit;">==</SPAN> <SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;">"FEEDERID"</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lyr<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>definitionQuery <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit;">=</SPAN> <SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;">"""FEEDERID = """</SPAN> <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit;">+</SPAN> <SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;">"'"</SPAN> <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit;">+</SPAN> str<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN>feederID<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">)</SPAN> <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit;">+</SPAN> <SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;">"'"</SPAN>

JoshuaBixby

Are you looping over fields in a layer or multiple layers? If the latter, are any of them group layers, map service layers, etc.... The error you describe will get generated if you try to return the fields of a layer that doesn't have fields.

MitchHolley1

Darren,

Thanks for the help.

I am currently running this Pythron script (v. 2.7.8) as a Script tool in a toolbox in ArcMap (v. 10.3.1).

When I test the code in the Python Window in ArcMap, I am able to list the fields in the (for f in fields:) loop. But, at the end of the prints, I am getting this error.

Any ideas as to why?

DarrenWiens2

This works for me:

<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> mxd <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>MapDocument<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"CURRENT"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN> df <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ListDataFrames<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN> feeder_field <SPAN class="operator token">=</SPAN> <SPAN class="string token">"FEEDERID"</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN> value <SPAN class="operator token">=</SPAN> <SPAN class="string token">"something"</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN> <SPAN class="keyword token">for</SPAN> lyr <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ListLayers<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> df<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; fields <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>lyr<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>fields
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> f <SPAN class="keyword token">in</SPAN> fields<SPAN class="punctuation token">:</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> f<SPAN class="punctuation token">.</SPAN>Name <SPAN class="operator token">==</SPAN> feeder_field<SPAN class="punctuation token">:</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; delim <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>AddFieldDelimiters<SPAN class="punctuation token">(</SPAN>lyr<SPAN class="punctuation token">,</SPAN>feeder_field<SPAN class="punctuation token">)</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lyr<SPAN class="punctuation token">.</SPAN>definitionQuery <SPAN class="operator token">=</SPAN> delim <SPAN class="operator token">+</SPAN> <SPAN class="string token">"='"</SPAN> <SPAN class="operator token">+</SPAN> value <SPAN class="operator token">+</SPAN> <SPAN class="string token">"'"</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

DanPatterson_Retired

did you throw in some prints to see what is returned .....and no... unicode is just fine.. it is the way of the future that began many years ago when 3.x was introduced

JoshuaBixby

Is feederID a number? If so, does this work?

lyr<SPAN class="punctuation token">.</SPAN>definitionQuery <SPAN class="operator token">=</SPAN> <SPAN class="string token">"FEEDERID = "</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>feederID<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

MitchHolley1

This addition was added to the script but still no results.

forestknutsen1

What about saving the mxd with arcpy? One would think that the call to arcpy.RefreshActiveView() would do it, but...

You could also add the below just to make it a little safer...

<SPAN class="" style="color: #101094; border: 0px; font-size: 13px;">if</SPAN><SPAN class="" style="color: #303336; border: 0px; font-size: 13px;"> lyr</SPAN><SPAN class="" style="color: #303336; border: 0px; font-size: 13px;">.</SPAN><SPAN class="" style="color: #303336; border: 0px; font-size: 13px;">supports</SPAN><SPAN class="" style="color: #303336; border: 0px; font-size: 13px;">(</SPAN><SPAN class="" style="color: #7d2727; border: 0px; font-size: 13px;">"DEFINITIONQUERY"</SPAN><SPAN class="" style="color: #303336; border: 0px; font-size: 13px;">):</SPAN>

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.