Kbase P97017: SDO w/foreign field relationship, setQueryWhere will not change sort criteria
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/11/2004 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.x
SYMPTOM(s):
Using setQuerySort to alternate the sort sequence for a browse from ascending to descending sequence
Once data has been sorted in one sequence it will never sort into the other sequence
Only happens when SmartDataObject has a foreign field relationship to another (parent) SmartDataObject
CHANGE:
Migrated from 9.1D to 10.0B
CAUSE:
This is a known issue being investigated by Development
FIX:
It is possible to workaround this issue by clearing out any existing sorting criteria before setting the new criteria. Use the following statement to clear out any existing sorting criteria:
DYNAMIC-FUNCTION('setQueryWhere' in SomeSmartDataObjectHandleGoesHere, '').