Author Topic: Location of element description in DB  (Read 3162 times)

tzafrir

  • EA User
  • **
  • Posts: 127
  • Karma: +0/-0
    • View Profile
Location of element description in DB
« on: November 16, 2016, 04:55:59 pm »
Hi,

Does anybody knows where the description part of the element exists on DB?

Thanks,
Tzafrir

Uffe

  • EA Practitioner
  • ***
  • Posts: 1859
  • Karma: +133/-14
  • Flutes: 1; Clarinets: 1; Saxes: 5 and counting
    • View Profile
Re: Location of element description in DB
« Reply #1 on: November 16, 2016, 06:04:17 pm »
Hi Tzafrir,

Elements are stored in t_object. The description (Notes field) is in t_object.Note.

However, if you're using EA's built-in SQL client ("Find in Project") it omits that column for some reason. But you can force it by renaming the column in the output.
Code: (SQL) [Select]
select Name, Note as Notes
from t_object
where something something

HTH,


/Uffe
My theories are always correct, just apply them to the right reality.

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8083
  • Karma: +118/-20
    • View Profile
Re: Location of element description in DB
« Reply #2 on: November 17, 2016, 08:49:39 am »
Try clicking on the button and selecting 'View Notes' | 'Full Notes' instead of aliasing the Notes field. (http://www.sparxsystems.com/enterprise_architect_user_guide/13.0/model_navigation/search_view.html)