Cannot query Note column in t_object

[hln]

I use the following query statements to query Note info in t_object table and it doesn't work:

• select a.Note as Note from t_object a => error

select Note from t_object => result doesn't contain Note column
select * from t_object => result doesn't contain Note colum
[/list]
It is OK if I alias Note column name as "Notes".
Is it a bug?

[KP]

Presumably you are using the Find in Project command? There is a View Notes option on the toolbar (5th button from left) which allows you to show in full, show preview or hide notes.

[Dermot]

The  Following works fine for the .eap file:
SELECT ea_guid AS CLASSGUID, Object_Type AS CLASSTYPE, Name, Note , object_type as Type, IsLeaf FROM t_object
Where object_type = "Requirement"
order by name
[DOB - see update KP's point above]

[hln]

The  Following works fine for the .eap file:
SELECT ea_guid AS CLASSGUID, Object_Type AS CLASSTYPE, Name, Note , object_type as Type, IsLeaf FROM t_object
Where object_type = "Requirement"
order by name
[DOB - see update KP's point above]

I updated first query statement in my post.
Result from your query doesn't contain Note column (as my second query).

[qwerty]

Note might be a reserved word. Try to brace it according to the SQL rules for your RDBMS (in EAP it would be [Notes], others use e.g. 'Notes').

q.

[Eve]

As KP said, the search window is helping you by recognising the Column named 'Note' and putting it in the special notes field. (Which is not shown as a column but a suppressible additional row for each item.)

For the same reason columns named CLASSGUID and CLASSTYPE don't show up in the view at all (but provide context handling/type icon)

You'll also find that the column Object_Type column can show the metatype derived from a stereotype instead of the value actually stored in the database.

It's not a raw view of the db tables, don't expect it to be.

[hln]

Presumably you are using the Find in Project command? There is a View Notes option on the toolbar (5th button from left) which allows you to show in full, show preview or hide notes.

Thanks KP, but I use these SQL in my add-in code.
Because of private reason, I don't want to alias Note column to another name