Author Topic: Show Notes in Modelview  (Read 219 times)

HLidstrom

  • EA User
  • **
  • Posts: 21
  • Karma: +0/-0
    • View Profile
Show Notes in Modelview
« 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

qwerty

  • EA Guru
  • *****
  • Posts: 10624
  • Karma: +233/-194
  • I'm no guru at all
    • View Profile
Re: Show Notes in Modelview
« Reply #1 on: August 15, 2019, 12:27:06 am »
Try to add
Code: [Select]
t_object.note AS [Notes]or something like that.

q.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 9537
  • Karma: +274/-27
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Show Notes in Modelview
« Reply #2 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

HLidstrom

  • EA User
  • **
  • Posts: 21
  • Karma: +0/-0
    • View Profile
Re: Show Notes in Modelview
« Reply #3 on: August 15, 2019, 06:50:54 am »
Thank you both!
That worked like a charm.