Class notes in database

[novikovigor]

Hello!
How can i find by SQL field "Notes" for class and associate it with this class?
I can find it for attribute (t_attribute.notes), tagged value (t_attributetag.notes), but i can't find for class.

I use model search in EA to create SQL queries.

[Aaron B]

Notes for elements such as Classes are stored in t_object.Note.

If the notes do not appear in the search results, you may need to enable display of Notes in the Model Search Toolbar.

Otherwise, maybe try using an alias on the Note column.  For example:

SELECT ea_guid AS CLASSGUID, Object_Type AS CLASSTYPE, Name, Note AS ElementNote from t_object

[Helmut Ortmann]

Hello,

select Name, Note from t_object
where object_type = 'Class' AND
           Name         like 'N#WC#'
order by Name

Just an example. SQL gives you a lot of power. If you want something different just ask.

Kind regards,

Helmut

[novikovigor]

Aaron B, Helmut Ortmann, thanks a lot!
I thought usages of getting notes for objects, attributes and tagged values are similarly, and for objects I used "notes" instead of "note"!

[Helmut Ortmann]

Hello,

to easily find the column names use the query:

Select * from t_object

Another option is the eBook from Thomas Kilian InsideEA.

Best regards,

Helmut

[novikovigor]

Helmut Ortmann, I know. I use SQL every day and "select *" was the first query that I create to define all columns in t_object and others tables. But "note" column is hidden in result set however it exists!

[qwerty]

The inline SQL editor obviously mangles the query before passing it to the database. The only way seems to be to write a script.

I also tried

Code: [Select]

SELECT [notes] as nbut that returned an error.

q.

[Aaron B]

As I said earlier, make sure that Notes are enabled on the Model Search Toolbar (i.e. set to either Notes Preview or Full Notes).  The search window seems to detect the default "Note" field and shows it as a special notes section rather than a normal column.

You can bypass this handling and just show it in a normal column by giving the notes column an alias (E.g. t_object.Note AS ElementNote)