topic Re: Delete definitionQuery different from 2.83 to 2.9 in Python Questions

Delete definitionQuery different from 2.83 to 2.9

DeanAnderson2 — Tue, 05 Apr 2022 16:24:26 GMT

Been using 2.8 for a bit and have had no problem clearing definition queries with the following code. If TurnQueryOn is true it sets the definition query. If it is false it sets definition query to None.

if TurnQueryOn:
RecordWhereClause = "CreatedByRecord = " + "'" + RecordNumber + "'"
for FilterLayer in FilterLayers:
mapFilterLyr = Map.listLayers(FilterLayer)[0]
if mapFilterLyr.isFeatureLayer:
mapFilterLyr.definitionQuery = RecordWhereClause
else:
for FilterLayer in FilterLayers:
mapFilterLyr = Map.listLayers(FilterLayer)[0]
if mapFilterLyr.isFeatureLayer:
mapFilterLyr.definitionQuery = None

I just upgraded to 2.9 (I still have a machine 2.83 so was able to double check). But the definition queries are no longer being deleted but just turns them to "inactive".

Is there something I am doing wrong? (I have seen other posts for this in the past and they appear to operate the same as mine does in 2.83.)

Re: Delete definitionQuery different from 2.83 to 2.9

DanPatterson — Tue, 05 Apr 2022 16:50:30 GMT

2.9 Layer—ArcGIS Pro | Documentation

2.8 Layer—ArcGIS Pro | Documentation

differences in the descriptions can be compared between the two

Re: Delete definitionQuery different from 2.83 to 2.9

DeanAnderson2 — Tue, 05 Apr 2022 17:17:02 GMT

Sorry found some code elsewhere. The following will remove all definition queries from a layer. In this case the layer is called "Anno0200Scale" as follows:

import arcpy

aprx = arcpy.mp.ArcGISProject("CURRENT")
Map = aprx.activeMap
Lyr = Map.listLayers("Anno0200Scale")[0]

Lyr_cim = Lyr.getDefinition('V2')

fTab = Lyr_cim.featureTable
fTab.definitionFilterChoices = None

Lyr.setDefinition(Lyr_cim)

I am not sure if this is the best way to do it but it does it. Please let me know if there are better ways.

Thanks