Display Classifier's Notes/Properties When Generating RTF in Sparx Enterprise Architect -

i'm using sparx enterprise architect 10.

i have instance of component on diagram , display both:

• the instance's notes; and
• the classifier's notes

when generating rtf documentation.

if have package structure this:

and have template publishes diagrams package , elements on package's diagram, result looks this:

it not there field available classifier's notes -- name of classifier. have custom sql?

edit - april 25:

is familiar sql or script required this?

it looks way add custom field report using fragment.

i've found if create template fragment displays field want , use custom query, can return information want.

create template fragment

create template fragment in enterprise architect.

• only check custom checkbox in sections tree.
• right click between custom start , end tags on page , choose insert custom field.
• type name of custom field (in case, chose use notes).
• save, click document options icon.

set template fragment document options

• specify sql search string on custom query tab.
• note note field must aliased (as notes)
• ensure document options tab has template fragment checked.

the sql needed is:

select note notes t_object object_id=(select classifier t_object t_object.object_id=#objectid#)

the custom query tab should this: