|
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 onto the web page. Make sure this filter is within a Table Panel.
Step 2: In the Design tab, double-click the filter control to display the 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 “greater than equal to” or “less than 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 |
| Operator |
Is greater than or equal Is less than or equal |
| 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 the filters that need to get the message from the button.
Step 7: Build and run the application.
|