Search with Query Builder
The Search with Query Builder tool provides the ability to perform advanced queries to find specific data. The tool allows the creation of any valid SQL "where" clause to filter data.
- Select a layer from the list of available layers.
Note: This will populate the list of fields with the fields of the selected layer.
- Select a field from the list of fields (for the selected layer).
Note: This will add the field name to the SQL "where" clause statement.
- Select an operator from the list of operators to add to your SQL statement.
Note: This will add the operator to the SQL "where" clause statement.
- If you know the specific value you want to query, update the SQL "where" clause text box.
- If you want to see a list of available values for the selected field, click the "Load" button. This will load all of the unique values for the given layer/field (limited by ArcGIS server).
Note: Check Display Coded Domain Values to see the descriptions of the domains instead of the code in the listed values in the query builder.
- Optional: Click the checkbox beside Display coded domain values to have the values displayed with their domain values.
- Optional: Click the checkbox beside Only Show Route(s) with Restricted Extents to restrict the route extents in the Route List to only show (have preselected) the From Measure and To Measure that contains the queried events.
- Optional: Click the checkbox beside Show Queried Events on Map to show the queried layer's symbology on the map that match your query when it is applied.
- Click Verify to validate the SQL statement. Look at the response message at the bottom of the tool for feedback on whether or not the statement is valid.
Note: All SQL statements will be passed, as-is, to ArcGIS Server and subsequently must adhere to the the constraints of ArcGIS Server query formats. By default ArcGIS Server requires the use of standardized queries - you can read more about standardized queries in ArcGIS Server here. This is especially relevant when working with dates.
Example: A valid standardized query with a date field is: "SOME_DT" > date '2009-01-01 00:00:00'.
- Click Apply to execute the query.
Note: The map will zoom to the first route in the selection. To view the selected routes, click the dropdown under Route to see all routes that were selected based on the text search.
To clear/reset the query builder back to its original state click Clear.