Multivalue query

Tonyalmeida

I am trying to create a script that allow me to enter more then one value to search, select and create a new feature from the selected. My script runs and finished fine but produces no out feature class. I am not sure if i am doing it correctly or not but any help would be great.

Thanks.

import arcpy  arcpy.env.overwriteOutput = True mxd = arcpy.mapping.MapDocument("CURRENT") df = arcpy.mapping.ListDataFrames(mxd, "Layers")[0] lyr = arcpy.mapping.ListLayers(mxd, "Taxparcels")[0]  #Define input/output input = arcpy.GetParameterAsText(0) fieldName = arcpy.GetParameterAsText(1) values = arcpy.GetParameterAsText(2) output = arcpy.GetParameterAsText(3)  #Build the where clause queryJoin = "' OR " + fieldName + " = '" whereClause = fieldName + " = '" + queryJoin.join(values) + "'"  #Select(input, output, whereClause) arcpy.SelectLayerByAttribute_management(lyr, "NEW_SELECTION", whereClause) if int(arcpy.GetCount_management("Taxparcels").getOutput(0)) > 0:     arcpy.Select_analysis("Taxparcels", output) 

Script parameters
are attached.

Image1.png

curtvprice

#Build the where clause whereClause = "{0} in ('{1}')".format(fieldName, "','".join(values.split(';')))

It's a little trickier than this because the each string value needs to be quoted.

#Build the where clause values = values.split(";")  # split values into list values = ["'{0}'".format(v) for v in values] # add single quotes whereClause = "{0} IN ({1})".format(fieldName, ",".join(values))  

This will generate a string that would work as a SQL expression like:

FIELD1 IN ('R12351','R12352')

UPDATE: Mathew Coyle's solution also works. I didn't see that he was joining using the string "<single-quote><comma><single-quote>", ie "','".  Neat!

He's right: Potato, tomato. I just can't resist showing off that most awesome of Python constructs, the "list comprehension", sorry.