SQL Query Modelbuilder

Question

Does anyone know if you can add an SQL query that applies to multiple features in modelbuilder?

Lebowski · Answer

No I am not using the Select by Attributes tool, should I be?

TedKowal · Answer

On a similar note and using "Select by Attributes", as Dan suggested that you can use a python script to build further complexity. Following is an example of a script that I used in a model to build a where clause to get a one to many related records .... hope this helps (it is crude but it gets the job done... I am a vb programmer not python) .... import arcpy, os # Local Variables OriginTable = arcpy.GetParameterAsText(0) #Sign Support --> Make Table View DestinationTable = arcpy.GetParameterAsText(1) #Sign Panels ---> Make Table View PrimaryKeyField = arcpy.GetParameterAsText(2) #SupportID /Sign Support ForiegnKeyField = arcpy.GetParameterAsText(3) #SupportID /Sign Panels def buildWhereClauseFromList(OriginTable, PrimaryKeyField, valueList): """Takes a list of values and constructs a SQL WHERE clause to select those values within a given PrimaryKeyField and OriginTable.""" fieldDelimited = arcpy.AddFieldDelimiters(arcpy.Describe(OriginTable).path, PrimaryKeyField) # Determine field type fieldType = arcpy.ListFields(OriginTable, PrimaryKeyField)[0].type # Add DBMS-specific field delimiters # Add single-quotes for string field values if str(fieldType) == 'String': valueList = ["'%s'" % value for value in valueList] # Format WHERE clause in the form of an IN statement whereClause = "%s IN(%s)" % (fieldDelimited, ', '.join(map(str, valueList))) #arcpy.AddMessage(whereClause) return whereClause def selectRelatedRecords(OriginTable, DestinationTable, PrimaryKeyField, ForiegnKeyField): """Defines the record selection from the record selection of the OriginTable and apply it to the DestinationTable using a SQL WHERE clause built in the previous definition""" # Set the SearchCursor to look through the selection of the OriginTable sourceIDs = set([row[0] for row in arcpy.da.SearchCursor(OriginTable, PrimaryKeyField)]) # Establishes the where clause used to select records from DestinationTable whereClause = buildWhereClauseFromList(DestinationTable, ForiegnKeyField, sourceIDs) # Process: Select Layer By Attribute arcpy.SelectLayerByAttribute_management(DestinationTable, "NEW_SELECTION", whereClause) # Process: Select related records between OriginTable and DestinationTable selectRelatedRecords(OriginTable, DestinationTable, PrimaryKeyField, ForiegnKeyField) #output same as Destination Table ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

DanPatterson_Retired · Answer

do you currently do that using the Select By Attributes tool?