Question about the RefGUID Tag Value

[ThomasAA]

I have spent a few days researching my question about the RefGUID tags, but could not find an answer. So hoping someone here can help!

We created a pre-defined RefGUID tag for one element to reference another. In our case we are mapping out health facilities in Nova Scotia, and the RefGUID tag we are using links the facility element back to the corresponding zone element. See image below:



That works great and really helps out with the traceability. However, when we go to export the model to an excel sheet or run a query or view it through Prolaborate - it only shows the GUID - is there anyone to have it display the name of the element instead? See in the image under the Zone column it shows the GUID instead of the name Northern.



For the Zone tag this is the code we are using:

Type=RefGUID;

Values=Class;

Stereotypes=OPOR_MDG::Zone;

Thanks for the help!

[Geert Bellekens]

That is because that is what is actually stored in EA, the guid of the linked element.

If you want to include that info in a query you can join t_object based on the ea_guid

Code: [Select]

select o.Name as object, zo.Name as ZoneName
from t_object o
inner join t_objectproperties tv on tv.Object_ID = o.Object_ID
and tv.Property = 'Zone'
left join t_object zo on zo.ea_guid = tv.Value
Geert

[ThomasAA]

Thank for the response, this is very helpful!

Do you know any idea we might be able to have the Element name appear in Prolaborate or if there is another sort of linked tag that would work for that?

Thanks again

[Geert Bellekens]

Thank for the response, this is very helpful!

Do you know any idea we might be able to have the Element name appear in Prolaborate or if there is another sort of linked tag that would work for that?

Thanks again

You'd have to ask that to the prolaborate guys.

Geert