Hi! We are trying to implement a two-level Item Group hierarchy in SBO 6.5.
For this purpose we created a User Table "@WQSITMGRPHIERARCHY") for linking each sub Item Group to top (parent) Item Group. The columns of this table (U_SubCode and U_TopCode, the type of both columns is Number 6) establish the links between Item Groups.
With Query Generator we created a Query (a SQL select) that we defined as formatted search for a new User Defined Field (type Alphanumeric 20) on the form.
It seems that we are not correctly getting the Item Group Code with references $[$39.0.0] or $[$OITM.ItmsGrpCod].
SELECT T2.ItmsGrpNam FROM "@WQSITMGRPHIERARCHY" T1, OITB T2 WHERE T1.U_TopCode = T2.ItmsGrpCod AND T1.U_SubCode = $[$39.0.0]
Pressing Shift-F2 in this field gives a blank field, Error 3006, or SBO "needs to close".
However, using a hard coded reference returns the correct Item Group Name:
SELECT T2.ItmsGrpNam FROM "@WQSITMGRPHIERARCHY" T1, OITB T2 WHERE T1.U_TopCode = T2.ItmsGrpCod AND T1.U_SubCode = '127'
Can you help us on this one?