Template for a RTF report of an activity diagram with linked requirements (EA10)

[jfzouain]

Hi Marc

Can you explain graphically, like with bullet points what do you want.
If I understand correctly with your post, this something that I have achieved in my eBook with a template no programming.

See here:
https://leanpub.com/uml-erpworkshop

[Marc Vanstraelen]

Geert,

I managed to create a query that uses the package guid to select elements up to 3 levels deep for which the related requirements are retrieved:

Code: [Select]

select oe.ea_guid as CLASSGUID, oe.Object_Type as CLASSTYPE, oe.*
from (((((t_object oe
inner join t_connector cn on oe.Object_ID = cn.End_Object_ID)
inner join t_object os on os.Object_ID = cn.Start_Object_ID)
inner join t_package pk on os.package_id = pk.package_id)
left join t_package p1 on pk.parent_id = p1.package_id)
left join t_package p2 on p1.parent_id = p2.package_id)
where (pk.ea_guid = '<Search Term>'
or p1.ea_guid = '<Search Term>'
or p2.ea_guid = '<Search Term>')
and os.Object_Type in ('UseCase','Activity')
and oe.Object_Type = 'Requirement'
and cn.stereotype = 'trace'
Again, it works perfectly in the Search Builder, but in the model document it still causes a "Document generation failed".
Are there maybe some requirements as to which attributes to add to the select based on the contents of the template?
I'm at a loss as to what to try next

[Geert Bellekens]

Marc,

The oe.* doesn't seem like a very good idea, but other then that this looks like it should be working (although I think I could write the query more efficient)
If you are at Aeropolis on Monday I'm happy to meet up during my lunchbreak and have a look.

I'm pretty sure you are almost there

Geert