Exact Match Search
This step configures an exact match comparison against either a text, number, boolean or date search column using the DataAssist Search server behavior. This is based on selecting Exact Match Search when adding a search comparison in step 2 of the DataAssist Search Wizard: Define your DataAssist Search.
A single database column in either a numeric, bit, text, or date format is searched against using a comparison specified through a form element. Specify the appropriate database column type specific to the type of search parameter being used. The results returned depend on whether the selected column in a given record is an exact match of the parameter passed from the form element.
Note: The comparisons configured using this wizard are designed for standard implementations. Advanced search configurations can be achieved by either editing the application of the DataAssist Search server behavior applied to your results page by this wizard, or by applying this server behavior directly to your results page.
A single database column in either a numeric, bit, text, or date format is searched against using a comparison specified through a form element. Specify the appropriate database column type specific to the type of search parameter being used. The results returned depend on whether the selected column in a given record is an exact match of the parameter passed from the form element.
Note: The comparisons configured using this wizard are designed for standard implementations. Advanced search configurations can be achieved by either editing the application of the DataAssist Search server behavior applied to your results page by this wizard, or by applying this server behavior directly to your results page.
Columns
Specify a column type that matches the content of the database column to be searched against. This ensures that exact match comparisons are made correctly based on the expected column format.Column: Select the database column to be searched against.
Column type: Select the column type that matches the type of search parameter to be passed from the form element on the search page. Available options are:
Column type: Select the column type that matches the type of search parameter to be passed from the form element on the search page. Available options are:
- Text
- Number/Boolean: Boolean is true or false value notated as 1 or 0 respectively. Typically captured as a bit field in the database.
- Date
Form fields
Specify the form element used to pass the parameter necessary to make the comparison. If you are using an existing search form (specified in Step 1 of the wizard, Search page selection), you have the option of either adding a new form element or using an existing form element. If creating a new form, specify a unique name for the form field to identify and label it. Upon completing the wizard, you may use Dreamweaver to customize the search page specific to your needs.Exact match form field: If using an existing search page and form, select if you wish to use an existing form element to make the comparison. All form elements contained in the form specified in step 2 of the wizard are available in the list.
New form field: If creating a new form or creating a new search parameter in an existing form, specify the name of a new form element to add to the search form. Select the type of form element to use. Options are:
New form field: If creating a new form or creating a new search parameter in an existing form, specify the name of a new form element to add to the search form. Select the type of form element to use. Options are:
- Text
- Select
- Radio
- Check