Example of a Search page
Filter Types
| Filter Type | Description |
|---|---|
| fieldname:SRCH | Provides a filter query equivalent to "EQUALS" in SQL |
| fieldname:LIKE | Provides a filter query equivalent to" ILIKE" in SQL |
...
On submission, the form will display the page rendered by the DCSearchResults.tmplt file. The value of REFVAL will be passed to the page and the values of the date input fields will be treated as a range search. In this particular example, the number of records returned will be limited to 100 with ten records displayed per page. For a full list of tags that may be used see the Parameter Tags Reference topic.
| Code Block | ||
|---|---|---|
| ||
....desc="Search" size="35" name="q:LIKE" id="retailer" class="select"/><input class="submitBtn" type='submit' value='Search' |
...
On submission, the form will display a drop down selection box with the heading 'Type of premises'. The first row in the list will be a default 'All' entry as seen in the first option value and this will be the 'selected' option. Then we are returning rows from the SCORES_PREMISE_TYPE table displaying the field PREMTYPEDESC. This code matches the first drop down in the following image Example of a Search page above.
Alternate way of defining your Search Template
...