Is there any documentation of database details

[Arshad]

Hi i need to find under which tables these details of an elements are stored NOTES and TESTCASES are stored .

In t_object i can't find the notes column in it.

Does the notes and Testcases are stored in seperate trable..! if so can anyone please tell me the table name..!  

[VKN]

In t_object i can't find the notes column in it.

t_object.Note
t_objecttests

[Arshad]

Hey thanks man actually t_objecttests Works.

But t_object.Notes doesn't return me any values.
select * from t_object works fine.
But select t_object.Note from t_object returns no results

[VKN]

Hey thanks man actually t_objecttests Works.

But t_object.Notes doesn't return me any values.
select * from t_object works fine.
But select t_object.Note from t_object returns no results

Try:
select Note as Notes from t_object

[Geert Bellekens]

EA does something funny with the Note column, so you'll have to give it another and only then it will show up.

Something else to remember is to always put the AS in UPPPERCASE.
It will not matter in some places, but it will in others.

Geert