Query operation / attribute types

[royvanmarrewijk]

Hi,

I have blocks with operations that use an enum as returntype and now I would like to write a query which gets values of the returned enum. For so far I have this:

Code: [Select]

SELECT opPar.*
FROM t_operation op, t_operationparams opPar
WHERE op.OperationID = 5929
AND opPar.OperationID = op.OperationID

Now the problem is that t_operationparams.Type contains the name of the enum and that I have multiple Enums with the same name (//not nice but for now out of scope). So how can I access the specific enum (by its Object_ID of guid)?

kind regards,
Roy

[Geert Bellekens]

Roy,

You should use the classifier:

Code: [Select]

select * from t_operationparams op
inner join t_object o on o.Object_ID = op.Classifier
Geert

[royvanmarrewijk]

Geert,

Thanks again!

The classifier of the operation is 0 in my case. I think this has something to do with a copy / paste action. If there is a workaround I would like to know  I the meantime I'll focus by fixing the problem at the source.

Roy

[Geert Bellekens]

If the classifier is 0 that means that the attribute or parameter isn't linked to an element and only has the name string to identify the type.

Geert