Element Notes in t_object

[JonathanP]

I am using a template fragment with a custom SQL query to retrieve related elements of a specific stereotype for a report. In my query I would like to retrieve the element "Notes", but am unable to find them in the t_object table. InsideEA states that the Notes column must be named, e.g. "SELECT t_object.Notes AS Notes, * FROM t_object" in order to appear, but that is not working for me.

Has the Notes column moved to another table or is there something else I need to do to retrieve it? I'm using EA 11 and have both a local EAP and a SQL Server 2008 repository and it fails on both.

-JP

[qwerty]

OMG what happens here? I added this remark once as EA pre-compiles the SQL and it had been working. Now it looks like it doesn't accept that. I will check and come back with an update.

q.

[qwerty]

Uh. My fault Seems I copy/pasted the wrong way and you're the first to fall into the pit. This will work:

Code: [Select]

select t_object.Note as [Notes] from t_objectI'll update the book immediately.

q.

[JonathanP]

That works, thanks q!

[KP]

There is a View Notes command in the toolbar for the Model Search. It gives you a choice of Hide Notes (which is default), Notes Preview, or Full Notes.

[qwerty]

Oh, indeed. I had to search a moment. It's the fifth icon top left.

q.

[JonathanP]

The View Notes button shows the notes, but not the column name. Unfortunately, the underlying problem is that the column name in t_object is "Note" and not "Notes" like it is in every other table that has notes. Not sure if that was a mistake or if you guys really just wanted to make it hard for us to get the notes j/k.