Kbase P179203: Dynamic toolbar Filter or calling 'assignQuerySelection' removes SDO OUTER-JOIN option in query phra
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/7/2011 |
|
Status: Unverified
SYMPTOM(s):
Dynamic toolbar Filter or calling 'assignQuerySelection' removes SDO OUTER-JOIN option in query phrase
Applying a filter with a Dynamics toolbar removes any OUTER-JOIN options applied to the SDO query at design time.
Applying a filter to an SDO query with outer joins, removes the joins from the SDO queryString property.
DYNAMIC-FUNCTION 'assignQuerySelection' IN hSDO removes OUTER-JOIN from the query phrase
FACT(s) (Environment):
All Supported Operating Systems
Dynamics 2.1A
Dynamics 2.1B
OpenEdge 10.2A
OpenEdge 10.2B
CAUSE:
This is expected behavior documented in release note OE00121140 Type: Behavior Change
Progress Dynamics and ADM2 filters upgraded for outer join management
FIX:
In order to preserve OUTER-JOIN, there are 2 options available :
1. Calling an other function just after ?assignQuerySelection: DYNAMIC-FUNCTION('assignBufferOuterJoin':U IN hSDO, "table-name", "").
or
2. Add getToggleOuterJoin() to the datalogic of the SDO.