Name:Filterable Table

Author: Ian Kerman

Version: 1.0

Created: 9/2011

Requirements: Pipeline Pilot 8.0 or later

O/S: Windows and Linux

Limitations: Works well with tables that have up to a few hundred rows. The JavaScript slows down considerably when you have more than that. A small performance gain is had by using a regular Table instead of the Interactive Table. For tables that will have a thousand or more rows of data, I would not use the 'onkeyup' event for the Text Boxes and instead create a button to call the filter functions using the 'onclick' event. Also, the text box filters work independently of each other, so you are currently only able to filter on one field at a time.

Purpose: The following protocols will create a table with one or more text boxes that can be used to dynamically filter your data in an HTML table. In the "FilterableTable" protocol, a single text box is used to filter on one property. The "FilterableTableWithDynamicFields" protocol will create one text box per property and attach a filter function based on specified criteria. Currently a front-matching text and a numeric less than filter is implemented by way of two separate JavaScript functions. This is easily expandable by adding additional JavaScript functions and adding additional logic to decide which text boxes to attach to the function.

To use, simply save the protocol to your client computer and open them up in the Professional Client.