The Active Now option does not work properly with Time Filter Expression
Last updated on APRIL 06, 2011
Applies to:
Oracle Application Server Integration BAM - Version: 11.1.1.2.0Information in this document applies to any platform.
Symptoms
When a report/alert consists of an entry on datetime/timestamp fields and having "Active Now" option checked, along with other entries, Active Now entry is evaluated first and the other entries are AND'ed with it.
In other words, it will always be (ACTIVENOW ENTRY) AND (REST OF THE ENTRIES)
Consider three entries in a filter like:
C1: col1 is equal to value1
C2: time_col is within the current time period current YEAR
C3: col2 is equal to value2
(C2 is entry with active now condition)
C2: time_col is within the current time period current YEAR
C3: col2 is equal to value2
(C2 is entry with active now condition)
Using headers and entries if the configuration is like:
C1 AND (C2 OR C3)
It will be evaluated as C2 AND (C1 AND C3)
Other examples:
an expression like C1 OR C2 OR C3 will be evaluated as C2 AND (C1 OR C2)
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms