The search control is automatically added to any table where one or more data fields have been designated as “searchable” by the application developer.
The GEN:SearchFilter tag searches for a text string within a table of records, allowing application users to search data in the displayed table. The resulting table control shows matching records. The search control is added automatically to any generated Show Table page where one or more fields (table columns) are designated as being searchable.
|
|
The search control is automatically added to any table where one or more data fields have been designated as “searchable” by the application developer. |
The SearchFilter tag displays a text box for the application user to enter a value to be searched. The search can be performed against any field in a table using a comparison operator. Only designated columns are searched by the search control.
If the display style is a text box, then the generated control must be bound to a button. When the button is pressed, the value entered by the application user is searched for within the table.
This tag requires a binding between it and another control, typically the table that it modifies. You must manually hook up the control to the table in the tag’s Properties dialog.
The fields displayed in the SearchFilter are not required to be displayed in the table shown to the user.
One of the principal features of the search controls is the interactive search feature. Interactive search provides list of suggestions after you type several characters. It fetches list of suggestions by sending request to a web service in the page’s code-behind file which in turn queries the database for a matching set of records.
The interactive search feature has several constraints:
Interactive search is an Enterprise Edition feature.
.NET Framework 2.0 / 3.0 are the only supported frameworks.
This feature can only be used with Search controls.
Interactive search will not work with Date fields.
This feature does not work with search controls which are inside a repeater. Also, the feature won’t work in search controls that are in a table’s repeater inside of another table.
We strongly recommend you index the specific database columns that participate in interactive search. This will significantly improve performance.
Interactive search is controlled by several pass-through attributes.
SearchFilter Display Properties
SearchFilter Binding Properties
SearchFilter Pass-Through Attribute Properties