Show Notes in Modelview

[HLidstrom]

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

[qwerty]

Try to add

Code: [Select]

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

q.

[Geert Bellekens]

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

[HLidstrom]

Thank you both!
That worked like a charm.