Kbase P48168: SmartFilter doesn't remove OUTER-JOIN option
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/10/2003 |
|
Status: Unverified
SYMPTOM(s):
SmartFilter doesn't remove OUTER-JOIN option
SmartDataObject has two tables joined with OUTER-JOIN
SmartFilter filtering on only fields in second table does not remove OUTER-JOIN option, so all records in first table are still returned
CAUSE:
Expected behavior.
The SmartFilter only changes the WHERE clause(s) of the SDO's, it does not change the join options.
FIX:
Use separate SDO's with separate SmartFilters, and dynamically link\unlink them as needed