Simple Filter dialog questions

[Statey603]

We are using the Simple Filter dialog (pfc_w_filtersimple) in PB 11. When we choose one of the columns and any Operator, the first item in the Value list is a blank row. Also....there is always one items missing from the values list and I noticed that the item always matches the value for this column in the first row of the DW that is being filtered. This problem only happens with 1 row of 12 and is consistently occurring.

I checked the code for the screen that uses the filter and cannot find any code that would remove or filter any of the filter columns.

I was wondering if anyone has seen behavior like this or might have usggestions on how to troubleshoot.

NOTE: I have tried debugging the events and functions for pfc_w_filtersimple and one thing that is a bit perplexing is I never see of_getvalues() get called which is where I believe the filter value list gets created.

If anyone can shed light on how the filter dialog gets its data, that would be awesome.

 

[Statey603]

fyi.............

I figured out what was causing this in case it is any help to others.

The Values list in the Simple Filter dialog was getting a blank row in it if any of the rows from the DW being filtered have a value (for the column selected in the filter dialog) that does NOT match any defined lookups. Null values are handled OK, but having ID values that can't be resolved causes a blank row in the values list.

 

[mbalent]

Thanks for the info.

Matt

"Nature forges everything on the anvil of time"

http://www.anvil-of-time.com