Does anyone know if you can add an SQL query that applies to multiple features in modelbuilder?
If it uses a tool in ArcToolbox and you can do the process using only the tools in arctoolbox, then yes. If it gets fancier, then you can incorporate scripts in the model. It may be easier in that case to simply script what you need.
Perhaps if you can show what it is that you are trying to do, other specific suggestions might come forward.
Yes all the tools I am using are in ArcToobox. Basically I would like a SQL and/or drop-down to select the appropriate county across several feature classes.
do you currently do that using the Select By Attributes tool?
No I am not using the Select by Attributes tool, should I be?
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 VariablesOriginTable = arcpy.GetParameterAsText(0) #Sign Support --> Make Table ViewDestinationTable = arcpy.GetParameterAsText(1) #Sign Panels ---> Make Table ViewPrimaryKeyField = arcpy.GetParameterAsText(2) #SupportID /Sign SupportForiegnKeyField = arcpy.GetParameterAsText(3) #SupportID /Sign Panelsdef 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).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 whereClausedef 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 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 DestinationTableselectRelatedRecords(OriginTable, DestinationTable, PrimaryKeyField, ForiegnKeyField) #output same as Destination Table
Retrieving data ...