Updated February 9, 2006
Iron Speed Designer V3.2
This example shows how to add a date range filter to a Show Table page. A date range filter consists of two text boxes, one for the start date and one for the end date of the filter range.
First, you can generally add a single date filter via the Table Panel Wizard in Iron Speed Designer. This is easy to do and ensures the filter is properly connected. If you are adding a Date Range filter, you might add the first of the two filters (the “start date” filter) through this method, and then add the second filter (the “end date” filter) by following the steps below.
Step 1: From the Controls toolbox in Iron Speed Designer, drag a filter control onto the web page. Make sure this filter is placed within a Table Panel.
Step 2: In the Design tab, double-click the filter control to display the Page Properties dialog for the filter control. On the Display tab, select “Text box” as the display style. Date range filters typically use text boxes for the “start date” and “end date”.
Step 3: On the Bindings tab in the Propreties dialog, select the database Field you wish to filter and the filter operator. For date filters, you should select “is greater than or equal to” or “is less than or equal to”.
Step 4: In the Bindings tab’s Event Notification section, select the table control to which the date filter applies. If there is only one table control on the page, it will be selected by default.
|
Binding |
Value |
|
“Start Date” operator |
is greater than or equal to |
|
“End Date” operator |
is less than or equal to |
|
Table control to filter |
The table you wish to filter |
Step 5: To create a date range filter, repeat the previous steps for the “end date” filter.
Step 6: (Optional.) If you have a “Go” button to start the filtering process, your application must instruct the table control to update itself when the user presses the Go button. However, instead of notifying the table control, it’s better to notify the filter control(s) and let it (them) forward the message to the table control. This ensures that the table control gets notified by the filter control rather than from the button control. This is done by selecting both filters to receive the message from the button.
Step 7: Build and run the application.