I would like to get the search the field value
'SURFACE LOCATION%' in column 'RefName' in layer '*.dwg Annotation'
This is what I have so far...
# Find the Dataframe df = arcpy.mapping.ListDataFrames(mxd, "Project Area") #Find the table named "*.dwg Annotation" Table = arcpy.mapping.ListLayers(mxd, "*.dwg Annotation", df) whereClause = """RefName" LIKE 'SURFACE LOCATION%'""" % RefName Anno = arcpy.SelectLayerByAttribute_management(AnnoTable, "NEW_SELECTION", whereClause)
Right now "Table" outputs the group layer name and the layer name.
However The link below shows that the the file path of the layer to work with SelectByAttribute.
Thoughts on how to get the file path of the layer?
and many thanks.