topic Re: Select Layer by Attribute in ArcPy in Python Questions

Select Layer by Attribute in ArcPy

MohammadrezaNikfal1 — Tue, 10 Apr 2018 19:35:06 GMT

I am working on a simple application. The user can choose either Numeric values or string values to select (i.e. valName). However if you write the where clause like this:

arcpy.SelectLayerByAttribute_management(lyr, "NEW_SELECTION", FieldName + opName + "'" + valName + "'")‍

It doesn't work for numbers and if you write like this:

arcpy.SelectLayerByAttribute_management(lyr, "NEW_SELECTION",FieldName + opName + valName)‍

It doesn't work for strings.

Any simple solution without if condition?

Re: Select Layer by Attribute in ArcPy

RandyBurton — Tue, 10 Apr 2018 20:16:49 GMT

"{} {} '{}'".format(FieldName,opName,valName) if type(valName) is str else "{} {} {}".format(FieldName,opName,valName)‍‍

You might try something like:

Re: Select Layer by Attribute in ArcPy

MohammadrezaNikfal1 — Sat, 11 Dec 2021 06:22:04 GMT

This worked for me:

if type(valName) is str or type(valName) is unicode:
   whereClause = FieldName + opName + "'" + valName + "'"
else:
   whereClause = FieldName + opName + str(valName)
arcpy.SelectLayerByAttribute_management(lyr, "NEW_SELECTION", whereClause)‍‍‍‍‍

Re: Select Layer by Attribute in ArcPy

RandyBurton — Tue, 10 Apr 2018 22:11:58 GMT

You can also use "in"

if type(valName) in (str, unicode) else ...‍