topic Re: SelectLayerByAttribute_management not selecting anything in Python Questions

SelectLayerByAttribute_management not selecting anything

JohnLay — Sat, 11 Dec 2021 19:11:46 GMT

I've read through most of the other similar questions and nothing so far has addressed my issue; most are about syntax.

I'm trying to select by attribute from a Feature Layer. But every time, Arc announces that it succeeded and nothing is selected. It works just fine using the same expression to select from a Table View. Any ideas?

expression = arcpy.AddFieldDelimiters(tempFeatureLayer, "BLDG_ID") + " LIKE '{0}%'".format(county)

arcpy.SelectLayerByAttribute_management(tempFeatureLayer, "NEW_SELECTION", expression)
if int(arcpy.GetCount_management(tempFeatureLayer)[0]) > 0:
    arcpy.DeleteRows_management(tempFeatureLayer)‍‍‍‍‍‍‍‍‍‍

It's an SDE Database feature class, if that makes a difference.

I've also tried rewriting the expression as below with the same result:

expression = """ "BLDG_ID" LIKE '37019%'"""‍

and

expression = "BLDG_ID LIKE '37019%'"‍

Re: SelectLayerByAttribute_management not selecting anything

LanceCole — Sat, 31 Aug 2019 01:59:19 GMT

John,‌

Your BLDG_ID attribute, is it text or numeric in the SDE database? What about the table?

If it is numeric in your SDE database, LIKE with text wildcards will only work on a text value in select by attribute statement. You can use a CAST statement to change BLDG_ID to a character string then use the LIKE statement with text wildcards such as "CAST(BLDG_ID AS CHARACTER(10)) LIKE '37019%'". Make sure to include a large enough character size by changing the "10" to what you need.

Re: SelectLayerByAttribute_management not selecting anything

JoshuaBixby — Sat, 31 Aug 2019 15:22:52 GMT

What back-end is your EGDB?