DataAssist Search Wizard: Step 2
The second step of the wizard is building your DataAssist Search criteria by configuring your search parameters and how they are compared against the information in your database.
Add different types of search comparisons, configure the form fields used to capture the associated comparison values, and specify the database column(s) that the comparison are made against.
Use the Search Comparisons pane to manage comparisons, the order in which they appear in the query statement, and to initiate the configuration of the details specific to each. Available comparison types, and links to detailed information specific to each, is available below in the section Configuring comparisons.
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.
The following details the first step, and the pages that follow details the steps specific to each comparison type available.
Select a comparison type, and click the Next button to go to the step specific to configuring the selected comparison. Upon completing a comparison configuration, click Next again to add that comparison to the Search element control pane.
Below is a list of each type available, within links to details specific to each.
Add different types of search comparisons, configure the form fields used to capture the associated comparison values, and specify the database column(s) that the comparison are made against.
Use the Search Comparisons pane to manage comparisons, the order in which they appear in the query statement, and to initiate the configuration of the details specific to each. Available comparison types, and links to detailed information specific to each, is available below in the section Configuring comparisons.
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.
Search element control
The wizard creates complex query statements based on the configuration of individual comparisons against data captured in a form. Each comparison is listed and managed in this control.
: Comparisons are added by clicking the Add (+) button. This initiates a step by step process for configuring individual comparisons (see Configuring comparisons below).
: Comparisons are removed by selecting an existing comparison and clicking the Delete button.
: The Edit button triggers the edit process for an existing comparison that is selected in the list.
: Statements are ordered by selecting them in the list and using the up and down arrows to change their relative position.
Separator
For a selected search element type, this determines how it relates to the comparison listed prior to it in the hierarchy.- AND: requires that both the prior comparison listed sequentially AND the comparison currently under configuration are satisfied by a database record for it to be returned as a result.
- OR: requires that either the prior comparison listed sequentially OR the comparison currently under configuration are satisfied by a database record for it to be returned as a result.
Configuring comparisons
Clicking the Add (+) button above the Search element control pane initiates a series of steps to define specific comparison types for your query.The following details the first step, and the pages that follow details the steps specific to each comparison type available.
Select a comparison type, and click the Next button to go to the step specific to configuring the selected comparison. Upon completing a comparison configuration, click Next again to add that comparison to the Search element control pane.
Search type
The first step in the process gives you the option of selecting from a list of available comparison types.Below is a list of each type available, within links to details specific to each.
Advanced Text Search: compares entered text against specified database column(s) to see if it includes the value
Date Range: compares a specified date against a minimum date and maximum date
Price Range: compares a numeric value against a numeric or currency database column
Numeric Range: compares a numeric value against a numeric database column
Exact Match: compares several datatypes to see if a database column contains an exact match for a specified value
Multiple Select List or Checkboxes: configures a list or series of checkboxes to pass multiple values to make an OR comparison against a database column
Single Checkbox: compares the values associated to the checked and unchecked states of a checkbox to a database column
Date Range: compares a specified date against a minimum date and maximum date
Price Range: compares a numeric value against a numeric or currency database column
Numeric Range: compares a numeric value against a numeric database column
Exact Match: compares several datatypes to see if a database column contains an exact match for a specified value
Multiple Select List or Checkboxes: configures a list or series of checkboxes to pass multiple values to make an OR comparison against a database column
Single Checkbox: compares the values associated to the checked and unchecked states of a checkbox to a database column