DataAssist Search Wizard
The DataAssist Search Wizard creates a customized search page to gather criteria to make database comparisons. The current page open in Dreamweaver is the page search results are passed to.
The wizard uses a specified available recordset on the current page to make comparisons against the database based on the search page criteria. It then configures the search page and the search form it contains.
Search page configuration is flexible and can accommodate creating a brand new page and form, create a new form within an existing page, or leverage an existing page and form. When creating a new form in an existing page that uses a template, you have the option of specifying the location the form is inserted within from a list of available editable regions on the page.
Once the high level page configuration is completed, the wizard steps you through the process of configuring each search comparison specific to your search form requirements. This includes associating form elements to comparison types, and determining the order of the comparisons within the query, as well as configuring the individual comparison details.
Upon completing the wizard, the search page is generated and opened, so that you can continue to customize it using Dreamweaver. Depending on the options selected, your existing search page is updated or a new page is created. The DataAssist Search server behavior is applied to the page you currently have open, and receives search results based on the search criteria passed to the current page from the search page.
Note: Additional configuration is necessary to display record results on the current page using the recordset filtered by the search. Dreamweaver's Repeat Region server behavior can loop through records for simple display in vertical rows. DataAssist's Repeating Table feature displays information in layouts that supports multiple records per row, as well as CSS attributes for alternating display rows.
The wizard uses a specified available recordset on the current page to make comparisons against the database based on the search page criteria. It then configures the search page and the search form it contains.
Search page configuration is flexible and can accommodate creating a brand new page and form, create a new form within an existing page, or leverage an existing page and form. When creating a new form in an existing page that uses a template, you have the option of specifying the location the form is inserted within from a list of available editable regions on the page.
Once the high level page configuration is completed, the wizard steps you through the process of configuring each search comparison specific to your search form requirements. This includes associating form elements to comparison types, and determining the order of the comparisons within the query, as well as configuring the individual comparison details.
Upon completing the wizard, the search page is generated and opened, so that you can continue to customize it using Dreamweaver. Depending on the options selected, your existing search page is updated or a new page is created. The DataAssist Search server behavior is applied to the page you currently have open, and receives search results based on the search criteria passed to the current page from the search page.
Note: Additional configuration is necessary to display record results on the current page using the recordset filtered by the search. Dreamweaver's Repeat Region server behavior can loop through records for simple display in vertical rows. DataAssist's Repeating Table feature displays information in layouts that supports multiple records per row, as well as CSS attributes for alternating display rows.
Access
The following locations in Dreamweaver open the DataAssist Search Wizard:- WebAssist Insert panel
- WebAssist > Database > DataAssist Search Wizard
Configuration details
The following pages in this section detail the configuration options available in the wizard:- Step 1: General configuration
select the recordset and the type of database that is queried, cConfigure the attributes of the search page, the form it contains, and the location of the form if within a template.
- Step 2: Define your database search
Configure your database comparisons and associated form elements used in your search form. The following links detail the comparison types available in Step 2.
- Advanced text search: compares entered text against specified database column(s) to see if it includes the value.
- Date range search: compares a specified date against a minimum date and maximum date.
- Price range search: compares a numeric value against a numeric or currency database column.
- Numeric range search: compares a numeric value against a numeric database column.
- Exact match search: compares several datatypes to see if a database column contains an exact match for a specified value.
- Multiple select list or checkboxes search: configures a list or series of checkboxes to pass multiple values to make an OR comparison against a database column.
- Checkbox search: compares the values associated to the checked and unchecked states of a checkbox to a database column.