Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: HLidstrom on August 15, 2019, 12:07:44 am

Title: Show Notes in Modelview
Post by: HLidstrom on August 15, 2019, 12:07:44 am

I wanted to show element name and notes in a package list view. Easy enough to create the view with default columns, but I cannot make it display the element notes. I changed the second column to t_object.Note. There is no error message, but the ModelView does not display a Note column, not even an empty one. Just three columns name, Status and Author.
What is the problem? What am I doing wrong? Or can't notes be displayed in an Element List ModelView?

This is my query:
SELECT t_object.ea_guid AS CLASSGUID, t_object.Object_Type AS CLASSTYPE, t_object.Name, t_object.Note, t_object.Status, t_object.Author FROM t_object INNER JOIN t_package ON t_package.Package_ID = t_object.Package_ID  WHERE t_package.ea_guid = '{B6117A4B-2E34-4138-A30D-655FB0CF425C}' ORDER BY t_object.Name

Title: Re: Show Notes in Modelview
Post by: qwerty on August 15, 2019, 12:27:06 am

Try to add

Code: [Select]

t_object.note AS [Notes]or something like that.

q.

Title: Re: Show Notes in Modelview
Post by: Geert Bellekens on August 15, 2019, 03:14:15 am

The trick is to give the notes column another name.
EA sometimes hides the note field, but only if it's called note. If you call it something else (I usually go with "Description") then EA doesn't know to hide it.

Geert

Title: Re: Show Notes in Modelview
Post by: HLidstrom on August 15, 2019, 06:50:54 am

Thank you both!
That worked like a charm.