Community
Participate
Working Groups
Description: I have a report, there are some null value level, I want to filter out all the level has value. I use is not null condition. But it doesn't work. So I remember may the level is not null value but is blank value. So how can I filter out that kind of level. Build number: 2.2.0.v20070607-0630 Steps to reproduce: 1, Open the attached report design 2, Set a filter on STATE level using filter is not null 3, Preview Expected result: Able to filter out the null value or blank value level Actual result: No effect
Created attachment 70438 [details] attached design file
In our implementation, aggregation levels with null value was firstly converted to empty string, so that the aggregation procedure can be executed. This proposal was approved by the HQ. So I think it's hard for us to filter the levels with empty string value ( who's original value is null ) using "is not null" filter.
Anyway, you can filter them with "not equal to" filter, who's argument is "". Thanks.
This would be a 2.2.1 feature. We should add support to <blank> and <null>, which are fundermentally different.
*** Bug 192786 has been marked as a duplicate of this bug. ***
suggest to use "not equal to" "" as the filter condition for this usage.
Hi Wenfeng How does user know the value is blank? He must use the isNotNull to filter all the null value at the first time. Another case see#192786, if the value is blank, but the value list are empty, what value should user specify? Tell him to specify the ""? I think the <blank> and <null> should be differentiated. So reopen the bug. Regards!
I agree there is difference between null and blank in database. But to end user or consumer, it is an advanced concept. If we were to support null concept, we need to change BIRT engine to present null value in all report items different from how blank string is presented. (for example uses <null> to present null string, while uses white space to present blank string. Until we have such presentation enh, blank and NULL value is the same to end user. Before we add a complete support of null value, I suggest we always convert DB null value to blank string at the data-engine data access layer. So there is no <null> value concept exposed to the report end user. Since there is no <null> string value in result set data, or data set data, all filtering condition should be checking if the string data is blank. User should not need to understand or even know about the concept of null string. Is there any UI or report design exposes the <null> string concept to end user in 2.2.0? if so, I suggest we fix those places to hide the null concept but treating both null string and blank string as if it is a blank string. In short, we assume that user does not need to know if a string is null or is blank, we assume that most usage case does not need to differentiate them. I agree we shall keep this bug open for future reference if we ever need to support null string concept in BIRT. I would like to see more usage demand before adding this feature.