Navigation: Ultimate Suite for PowerBuilder Help >


Send comments on this topic.




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.



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)

Copyright © 2023 Werysoft Inc.