Summary
Many parts of Databuild use a common search routine
Details
Actual details of this screen vary with the parent screen that it was called from, but the logic stays the same
A series of condition rows is displayed. A drop-down above the grid specifies whether ALL or ANY of the included conditions are to be met.
Each row of the grid displays
| • | Include If ticked, this row is to be included in the search |
| • | Field A drop-down list displays all the fields that are appropriate for this search routine |
| • | Condition A drop-down list displays all conditions appropriate for this field |
| • | Value1 Displays your required value. Greyed out if not appropriate for this condition |
| • | Value2 Displays your required value. Greyed out if not appropriate for this condition |
Below the grid, a sorting field can be selected, and the SQL select statement is displayed. Experienced users can modify this text box for more complicated searches.
Toolbar
File Menu
Load Loads a previously saved set of search conditions
Save Saves the current search conditions for later loading
Creates a new search row
Deletes the current or Selected rows(s)
Selects ALL rows. Cancels previous searches
Clears all INCLUDE ticks
Applies the search and closes routine if search is successful
Closes the routine