How to select tag values for operation parameters

[heydukr]

Hello, I've defined t_operationparams items in EA as a detail row for t_operation row connected via OperationID realation key. I've add a tag value to the operationparam. I'm able to select the operationparam:
SELECT * FROM t_operationparams a  where a.Name = 'IP_ADDRESS' 
Will You please give me an advice how to select matching tag to this param? And what raltaion key shall I use?

SELECT * FROM `ea-integration-platform`.t_propertytypes a where a.Property = '...'   - is a possibility but I miss a raletion key

Thank You

[Geert Bellekens]

Parameter tags are stored in t_TaggedValue IIRC

Geert

[qwerty]

Almost. It's t_oparationtag

q.

[Geert Bellekens]

Almost. It's t_oparationtag

q.

For parameters? Are you sure?

In my parameter wrapper class I have this:

Code: [Select]

        protected override string getTaggedValueQuery(string taggedValueName)
        {
            return @"select tv.PropertyID from t_taggedvalue tv
where tv.TagValue like '" + taggedValueName + "' "
                + " and tv.ElementID = '" + this.uniqueID + "'";
        }
Geert

[qwerty]

My, bad. I attached it to an operation :-( But now, how can a parameter be tagged?

q.

[Paolo F Cantoni]

My, bad. I attached it to an operation :-( But now, how can a parameter be tagged?

q.

EA lets you do it.  Select a parameter for an operation (I used the Primary Key operations on a Table), then add the tag.  As Geert said, they end up in t_taggedvalue.

Paolo

[qwerty]

I guess, since you mention it, that this is only possible for database opertation parameters (I dealt with that only many years ago). Normal classes do not offer creation of tags.

q.

[Geert Bellekens]

I guess, since you mention it, that this is only possible for database opertation parameters (I dealt with that only many years ago). Normal classes do not offer creation of tags.

q.

They do. It works the same as with associationends.
On the operation properties Tags, there are sections for all parameters. If you click on a parameter and then use the "add new tag" button, it adds a tagged value to the parameter.

Geert

[qwerty]

You are right (as always), Geert. I never was aware of that... (the way it works is EAUI, also as always).

q.

[heydukr]

Thank You very much, I've got it:

SELECT b.Name AS param_name
         , a.Notes  AS param_tag_value
   FROM  t_TaggedValue a
           , t_operationparams b
  WHERE a.TagValue = 'TAG NAME'  
      AND a.ElementID = b.ea_guid

[Geert Bellekens]

Yes, but I would write it differently:

Code: [Select]

SELECT opr.Name AS param_name
,tv.Notes AS param_tag_value
FROM  t_TaggedValue tv
INNER JOIN t_operationparams opr on opr.ea_guid = tv.ElementID
WHERE tv.TagValue = 'TAG NAME' 
This way you differentiatie between your join criteria and your selection criteria

Geert

[heydukr]

You're right, thank You