Hi,
I have a diagram with several classes with attributes and tagged values on the attributes.
I need to generate documentation where each attribute is on a separate row of the table. The first column will contain the attribute name and the other columns will contain the TV values. Currently, all attributes are being generated into a single row of the table.
Unfortunately, I'm not very skilled at creating templates and I only know basic SQL. I tried to resolve the situation in the following way.
1) Basic templatediagram >
element >
< element
< diagram
element >
attribute >
<table>
<tr>
<th>Attribute (name of attribute)</th>
<th>Type (type of attribute)</th>
<th>Format (tagged value)</th>
<th>Note (note of attribute</th>
</tr>
<tr>
<td>{Template - a3_Class_Att_Name_API}</td>
<td>template</td>
<td>template</td>
<td>template</td>
</tr>
</table>
< attribute
< element
< package
2) Template - a3_Class_Att_Name_APIOnly the custom field "Name" base on this script (custom sql query):
select
a.Name as Name
from t_attribute a
left join t_object o ON a.object_ID = o.object_ID
left join t_attributetag at ON a.ID = at.ElementID
where
o.object_id =#OBJECTID#
Thank you very much for your help.