topic Building SQL Expression using printed results? in ArcGIS Pro Questions

Building SQL Expression using printed results?

Davec43 — Thu, 28 Jul 2022 12:28:37 GMT

I run a searchcursor that prints results. How do I use those results to build an SQL Expression in Python?

lyr = "layer name" events = arcpy.da.SearchCursor(lyr, ['Event']) unique_events = list(set([row[0] for row in events])) unique_events print(unique_events)

I then get values

[1, 2, 3, 4, 5, 6]

How do I take those values in python and insert them in sql expression for whats in the ()?

arcpy.management.SelectLayerByAttribute("Lyer2", "NEW_SELECTION", "Event IN ()", None)

Re: Building SQL Expression using printed results?

RhettZufelt — Thu, 28 Jul 2022 18:10:37 GMT

one way:

sql = "Event IN(" + ','.join(map(str,unique_events)) + ")" arcpy.management.SelectLayerByAttribute("Lyer2", "NEW_SELECTION", sql, None)

>>>sql

'Event IN(1,2,3,4,5,6)'

Re: Building SQL Expression using printed results?

JoshuaBixby — Thu, 28 Jul 2022 18:31:23 GMT

You can streamline it by not converting to list but a tuple.

lyr = "layer name" events = arcpy.da.SearchCursor(lyr, ['Event']) unique_events = tuple(set([row[0] for row in events])) arcpy.management.SelectLayerByAttribute("Lyer2", "NEW_SELECTION", f"Event IN {unique_events}", None)

Re: Building SQL Expression using printed results?

Davec43 — Mon, 01 Aug 2022 12:57:04 GMT

Awesome it worked!