SQL searching and Model Documents

[jon earl]

Hi,

I'm looking at using EA's RTF Master/Model documents to generate a glossary table, based on a tagged value search:

select o.ea_guid AS CLASSGUID, o.Object_Type AS CLASSTYPE, o.name as Name, o.Object_Type AS Type, package.name as 'Package Name', properties.value as 'Note'
from (((t_object o
left join t_xref stereo on stereo.Client = o.ea_guid)
inner join t_package package on o.package_id = package.package_id)
left join t_objectproperties properties on o.Object_ID = properties.Object_ID)
where
properties.Property like "*Glossary*"
order by o.name asc

(I'm aware that there are a couple of lines of SQL here I don't need - e.g. the stereotype one).

This works fine in the Model Search browser - I end up with a list sorted by name.

When I then use this Model Search as an input into a model document, I no longer end up with an ordered list - it appears to be sorted by element creation date.

This seems to be a bug. However, I then tried a couple of other workarounds:

Modifying the template associated with the model document (so that it sorts by element name, etc.) makes no difference - the output still is sorted by element creation date.

Modifying the master document creation settings also makes no difference - the output is sorted by creation date.

Is this expected behaviour?