The attached protocol makes use of the SCRIPTABLE DATA CONNECTOR functionality to emulate the filter capability available in Excel. A table is built using an automated in-line method whereby each property on a data record entering the subprotocol is added as a column in the table. When run clicking on a column in the table pops up a DIV which contains a title, two control buttons and a series of checkboxes, one for each unique value of that property. If a checkbox is ticked then the table will show those values for that property, if not ticked then they will be excluded. Row visibility is dependent upon the status of the corresponding checkboxes for all property values in that row (LOGICAL AND). The process works be keeping a track of which checkboxes across all properties are ticked and comparing values in the table against those checkboxes. The comparison is used to create an array of data connector row IDs which are published to hide/show the rows.

REQUIREMENTS:

PP VERSION: PP8.0 or higher

PP COLLECTIONS: generic, reporting

BROWSER: JavaScript enabled, tested on IE8 and FireFox6