Kbase P78367: Dyn 2.1A02 Treeview, data link broken if foreign field is in grand parent level
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/04/2004 |
|
Status: Unverified
FACT(s) (Environment):
Dynamics 2.1A
SYMPTOM(s):
FUNCTION function given invalid or Unknown context to run IN. (5705)
Using the Dynamic treeview
Error occurs when calling getDataSource API from a fieldname.calculate function (to work out value of a calculated field).
CHANGE:
Applied Service pack 2 on Dyn 2.1A (so 2.1A02)
CAUSE:
The data link to a SDO node was broken because of the following scenario with three levels of SDO nodes (grand parent, parent, child):
- SDO-node, SDO table1 contains fieldA
-- SDO-node, SDO table 2 that does NOT contain fieldA, but contains fieldB (foreign field is fieldC)
--- SDO-node, SDO table3 contains fieldA and fieldB, and needs to be in sync with the SDOs on level 1 and 2. Foreign fields is: table3.fieldA,fieldA,table3.fieldB,fieldB
It seems that 2.1A01 was able to handle foreign fields with the grand parent level.
FIX:
Solution is to define a join in the 2nd SDO to make fieldA also available in this parent SDO, as illustrated bellow:
- SDO-node, SDO table1 contains fieldA
-- SDO-node, SDO table 2 and table1 (joined) so it has both fieldA and fieldB
--- SDO-node, SDO table3 contains fieldA and fieldB, now it is enough to be in sync with the SDO of 2 only.