Simple Database Search - Search Help
Since Simple Database Search is a configurable utility, the provider of the database you are searching may have opted not to use some of the functionality discussed below. If you have further questions about how to search a particular database, you should contact the provider of that database.
Using the search form
With Simple Database Search a provider can opt to allow a user to search the database by:
- entering a search string
- selecting a value from a select list
- selecting a date range
- a combination of the above
Searching with a search string
By default, Simple Database Search will create a search form with an input field where a user can enter a word or a phrase. Simple Database Search will look for records in the database that contain the word(s) in the search string. Simple Database Search will further allow a user to specify that the word appears in a selected field or fields.
Searching from a select list of predetermined values
If there are fields in the database that have a finite list of possible values, the provider can opt to present a select list from which the user can pick possible values to search. The provider must create a selectlist option in the configuration file for each field that is applicable.
Searching for records within a date range
If the datebase has a field that contains all dates, the provider can opt to allow users to search for records that fall within a date range. The provider must create a daterange option in the configuration file for the dated field.
Combining search string and select list searches
If the provider allows it, a user can search for both a search string and a value from a select list.
Using a multiple select list
If the provider chooses, there are certain select lists presented in the Simple Database Search search form that allows the user to select multiple items from the list:
How the user selects multiple items from a select list will depend on the operating system of the user's machine.
- select which fields to search
- select which fields to display
- Xterm Users: Click on the fields to select or deselect more than one field.
- Mac Users: Hold down the SHIFT key to select more than one field.
- PC Users: Hold down the CONTROL key to select or deselect more than one field.
Sorting search results
The records from the database that are returned with the search results will appear by default in the order in which they appear in the database. A provider can opt to allow the user to change the order of the records in the search results.
If the searchform contains a select list like:
the user can instead choose one of the above fields by which to sort the search results. Selecting one of the above fields will affect the order of the records but will not affect the order of the fields in the record. The fields in the record will always appear in the order in which they appear in the database.
An example of how this selection affects the order of the search results is available.
penn web developers