Where can we find Notes

[sravang]

In which database table can we find Notes related to that element in sparx database.

Thanks,
Sravan

[Geert Bellekens]

t_object.note

Geert

[sravang]

Object_ID
Object_Type
Diagram_ID
Name
Author
Alias
Version
Package_ID
StereoType
Ntype
Complexity
Effort
Style
Backcolor
BorderStyle
BorderWidth
FontColor
BorderColor
CreatedDate
ModifiedDate
Status
Abstract
Tagged
PDATA1
PDATA2
PDATA3
PDATA4
PDATA5
Concurrency
Visibility
Persistence
Cardinality
GenType
GenFile
Header1
Header2
Phase
Scope
GenOption
GenLinks
Classifier
ea_guid
ParentID
Runstate
Classifier_guid
TPos
Isroot
IsLeaf
Isspec
IsActive
StateFlags
PackageFlags
Multiplicity
StyleEx
ActionFlag
EventFlag.

These are the columns I see in t_object table. I don't see note in t_object table

[qwerty]

That's what EA shows you. Be explicit and use Note as Notes in the query as result column.

q.

[sravang]

That worked.

Thanks,
Sravan

[Geert Bellekens]

These are the columns I see in t_object table. I don't see note in t_object table

That is because you are not looking at the actual data, but the data through EA's view.

There is actually an option in the search window that allows you to choose whether to show the full notes, an abstract of the notes, or no notes at all.
If you choose no notes, EA will hide that column from you (based on the name)
Theres similar dark magic that happens with the Object_type field.


Geert