Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: tzafrir on November 16, 2016, 04:55:59 pm

Title: Location of element description in DB
Post by: tzafrir on November 16, 2016, 04:55:59 pm

Hi,

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

Thanks,
Tzafrir

Title: Re: Location of element description in DB
Post by: Uffe 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

Title: Re: Location of element description in DB
Post by: Eve on November 17, 2016, 08:49:39 am

Try clicking on the (http://www.sparxsystems.com/enterprise_architect_user_guide/13.0/images/docoptions.png) 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 (http://www.sparxsystems.com/enterprise_architect_user_guide/13.0/model_navigation/search_view.html))