Document Generation: Including Fully Qualified Names for RefGUID Tagged Item

[sousac]

My model includes a RefGUID tagged value to establish a relationship between columns (attributes) for source->target specification.  The RefGUID works well in the model, however, it does not present a fully qualified name when shown in the UI or included in documentation.

I'd like to show the parent class (table) for the referenced attribute to offer a fully qualified name.

e.g., if my RefGUID tag references an attribute within Class1 called "FirstName", I want to convey (in documentation) that the referenced attribute is Class1.FirstName

After including the tags collection in a document template, there doesn't seem to be any properties I can work with.

I would likely have access to the referenced object in a script.
Is scripting to an output file the only option or am I missing something in the document generator.

[Geert Bellekens]

Hi,

You are not missing something obvious.
You could use a script fragment, but in this case a simple SQL fragment would be enough.

Geert

[sousac]

Thanks Geert.

So I would use a SQL snippet/fragment.

The SQL would join the tag, attribute, and object where the GUID stored in the tagged value = GUID of the referenced attribute.

Something along the lines of:

Select <expression to produce the name> from < join tag to attribute, join attribute to object > Where <attribute.GUID = tag.value>

[Geert Bellekens]

yes, exactly

Geert