RFT Export: Filter attributes via Tag

[xabi]

Hello,

I like to export my EA Model via RTF and I need some help. Maybe somebody of you can give me a hint.

I have a lot of attributes with different tags. I want to export only attributes which contains specific tags. Is that possible?

There is a functionality for features but I can't find it for attributes.

Thanks in advanced and have a nice day

[Geert Bellekens]

You can add filters for attributes, but tagged values on attributes are not in the filter list.

So the only alternative is to write an SQL fragment that returns only the attribute details you are interested in.

Geert

[xabi]

Thanks for the reply.

Do you have a kind of prototyp or example for me? Where in the RTF Template I can add SQL

Thanks in advanced

[Geert Bellekens]

There's one in the template UCD_Linked Requirements in the sample MDG you can download from my website: https://bellekens.com/2015/11/12/tutorial-generate-complex-documents-from-enterprise-architect-with-a-two-step-semi-automated-approach/

Instructions can be found in the manual: https://sparxsystems.com/enterprise_architect_user_guide/16.0/model_publishing/custom_sql_fragments.html

Geert

[xabi]

Thanks have a nice day

[xabi]

Hi Geert,

I downloaded your example but Im not able to make it working. I created a new Template Fragment and I added a "Custom Query". But it doesn't matter what I add all attributes are displayed in the RTF Export.

The Use Case is that I like to export only certain Attributes which contains a tag with the name "Copy Field" / <UML:TaggedValue tag="Copy Field"

I tried the following SQL

select *
from ((((t_object c
inner join t_package  package on c.package_id = package.package_id)
left join t_package  package_p1 on package_p1.package_id = package.parent_id)
left join t_package  package_p2 on package_p2.package_id = package_p1.parent_id)
left join t_package  package_p3 on package_p3.package_id = package_p2.parent_id)
where
c.TaggedValues like 'Copy Field'

By the way where can I test SQL Statements?

Thanks in advanced and have a nice day

[Geert Bellekens]

You can execute queries in the SQL Scratch pad in the model search.

I'm not sure what exactly you are looking for, but tagged values on elements are stored in t_objectproperties, and attributes can be found in t_attribute

Geert

[xabi]

Hi Geert,

thanks for your support.  Im really new with Enterprise Architect thanks for the hint with the SQL Scratch Pad.

Every Class e.g. Bug, Requirement (in our context Object/Artefacts) have certrain attributes like ID, Summary, Description and much more.

In our Word Export I want to export only the attributes which contains TaggeValue like CopyField. I cannot use the the Stereotype because Im using it for something else.

Can you please be so kind and help me out with the SQL? That would be really great.

Thanks in advanced and have a nice day

[skiwi]

You might find this useful
Inside Enterprise… by Thomas Kilian [Leanpub PDF/iPad/Kindle]