Wener, If TypeTree is a collection it should map to SQL as a "child table" GAS.ObjectType_TypeTree or somesuch, in which case
WHERE :ObjectType IN (SELECT <ID> FROM GAS.ObjectType_TypeTree) *sounds* like what you need, but (1) Don't know if you can replace the first part before IN with a parameter and (2) must replace <ID> with the column name that refers back to the ObjectType in the "child table" > and by the way how could I get some objects that are not contained in a > subclass > class type1 > class type2 extents type1 > class type3 extends type2 I *think* there is a column "x_classname" which projects the specific class of an instance to SQL, you could use that... Sorry about the uncertainties, Cach� SQL is not my main strength :( HTH, Ram�n
