Adding Date Range Filters to a Page
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.
- Alan Fisher, Chairman of Iron Speed, Inc.

February 14, 2006
Iron Speed Designer V3.2

Procedure
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.

About the Author
Alan S. Fisher
Co-Founder and Chairman of Iron Speed, Inc.

Mr. Fisher was a General Partner at Outlook Ventures, Inc., a venture capital company prior to co-founding Iron Speed, Inc. He co-founded Onsale, Inc. (now Egghead.com) and was its Chief Technology Officer from July 1994 to December 1999. He also Co-founded and was President of Software Partners, Inc, a developer and publisher of software products from August 1988 to July 1994. From April 1984 to August 1988, Mr. Fisher served as Technical Marketing Manager and Product Development Manager for Teknowledge, Inc., a developer of artificial intelligence software products. From June 1981 to April 1984, he served as a member of the technical staff for AT&T Bell Laboratories. Mr. Fisher serves on the Board of Directors of Infodata Systems Inc. (NASDAQ:INFD) an e-business consulting services company; He formerly served on the board of a number of companies including Onsale, Inc. (later Egghead.com and now Amazon.com), and FatBrain, Inc. an Internet retailer of technical and professional books.

Mr. Fisher received his B.S. in Electrical Engineering from the University of Missouri and received his M.S. in Electrical Engineering from Stanford University.



  Privacy Statement