PowerFilter

Overview

PowerFilter is an easy-to-implement datawindow filtering component that gives your applications auto-filtering functionality similar to that found in Excel. It works with your existing datawindows, just add one control to your window and as little as 3 lines of Powerscript to implement.

Features

Generates a dropdown checklist with unique values for each column. Check as many items in as many columns as desired to define the filter

Includes a Custom filter dialog with pre-defined options based on datatype (Last Month, Next Month, Last Year, This Year, Greater than, Contains, Above Average, etc.)

Supports grid and tabular datawindows , both columns and computed fields

Supports all standard data types

Supports custom column formats including format expressions

Multilingual support built in, no coding required. A single .pbl supports multiple languages at runtime

Dropdown Datawindows, ListBoxes, and Code Tables filter and sort on the Display value, not the data value

Non Visual Object (NVO) implementation. Visual checkbox implementation also still supported for backwards compatibility

DisplayAsPicture support. Dropdown and custom filter dialogs automatically display images to select/filter if the column displays images using the DisplayAsPicture property

 Appeon compatibility

 Conditional visibility support. Filter button for a column has the same visibility properties as the column itself

Option provided to maintain existing groups when using the sort column option

Wildcard and case matching options provided

Quick sort by column built into control, with ability to disable the feature

Includes Instance variable options definable in the painter to modify appearance or behavior

Optional object functions are available to further modify behavior

Component can identify the columns and use default header text, or developer can specify which columns to allow user to filter on and can redefine header text via function calls.

Works with existing datawindow controls in your application, with as little as 3 lines of Powerscript to code

Not PFC-based, but compatible with PFC-based applications

Enhanced features in PB 11.5 and above versions:

oDatepicker for custom date or datetime filters

oTreeview presentation in Dropdown, allowing selection of entire years and/or months for date and datetime columns

oPowerTips (ToolTips) for each column describing the filter applied

oTransparent/Gradient option highlighting, just like Excel 2007

New in version 2.0!

oSearch Bar added to Dropdown, dynamically filters the dropdown list as you type to include only items matching what you type

oIncrementally add Search results to previous results with Search Bar

oExpand/Collapse Date Tree option added to fully expand and collapse the branches of the date tree

oImproved Performance for high data volume. Code performance improved, and optional parameters to limit the time spent building the dropdown list

oof_SetBackgroundColor function to optionally set Background Color

oof_SetFontColor function to optionally set Font Color

oof_SetFontName function to optionally set Font Name

oof_Set_Post_Filter_Event to identify an event on a parent object to execute after filter is applied

oResize from side and bottom, not just corner of the dropdown list

oDropdown placement and sizing improved for smaller window height.

oSecondary options lists resize and scroll if needed to fit window height

oTested to work with 96 and 120 dpi.

oGroupcalc() after filter applied

oApostrophes in Header Text handled

oButton x coordinate bug fixed (integer changed to long for very wide datawindows)