Author Topic: Where to find NOTES for an object in the repository?  (Read 9594 times)

BCGoitcwoodard

  • EA User
  • **
  • Posts: 25
  • Karma: +0/-0
    • View Profile
Where to find NOTES for an object in the repository?
« on: September 15, 2021, 05:08:58 am »
Not in t_object?

Also, Can we find documentation of the usage of PDATA1..PDATA5columns of t_object?

Thank you,
  CCW

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8061
  • Karma: +118/-20
    • View Profile
Re: Where to find NOTES for an object in the repository?
« Reply #1 on: September 15, 2021, 08:18:08 am »
If you're writing a SQL query in EA there's special handling for a column named 'Note'. On my EA (and I don't think it has changed recently) the second last button on the toolbar in the search window there is an options button. You can choose how notes are displayed there.

No, there's no documentation of how the different types of objects use the PDATA columns.

BCGoitcwoodard

  • EA User
  • **
  • Posts: 25
  • Karma: +0/-0
    • View Profile
Re: Where to find NOTES for an object in the repository?
« Reply #2 on: September 15, 2021, 09:52:25 am »
Thank you for the prompt response.   Sorry, but I do not know where to find the "Search Window" you refer to.  Could you explain a bit more precisely or attach a screen shot?
Thanks in advance.
  CCW

BCGoitcwoodard

  • EA User
  • **
  • Posts: 25
  • Karma: +0/-0
    • View Profile
Re: Where to find NOTES for an object in the repository?
« Reply #3 on: September 15, 2021, 10:22:31 am »
I found a "Find in Project" query builder window, but I cannot see that it exposes the generated SQL underlying the search, e.g., in the SQL Scratch Pad tab. Missing something, wrong place to look, something else?

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8061
  • Karma: +118/-20
    • View Profile
Re: Where to find NOTES for an object in the repository?
« Reply #4 on: September 15, 2021, 02:19:02 pm »
I think I misunderstood your question.

t_object.Note is where object notes are stored. If you running a query in the search window within EA that column is hidden by the options to handle notes.

If you're trying to access the data with SQL from outside of EA, there's not much help that I can provide.

BCGoitcwoodard

  • EA User
  • **
  • Posts: 25
  • Karma: +0/-0
    • View Profile
Re: Where to find NOTES for an object in the repository?
« Reply #5 on: September 15, 2021, 05:33:03 pm »
Of course!  How did I miss that!?

Thanks again,
  CCW

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13251
  • Karma: +554/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Where to find NOTES for an object in the repository?
« Reply #6 on: September 15, 2021, 06:02:54 pm »
Of course!  How did I miss that!?

Because the column is Note and not Notes as in all other tables that contain notes.

Geert

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: Where to find NOTES for an object in the repository?
« Reply #7 on: September 15, 2021, 06:47:44 pm »
Because the column is Note and not Notes as in all other tables that contain notes.

Geert
Which is an uncommon consistency being sooo unlikely for EA.

q.

wivel

  • EA User
  • **
  • Posts: 242
  • Karma: +12/-1
  • Driven by Models
    • View Profile
Re: Where to find NOTES for an object in the repository?
« Reply #8 on: September 15, 2021, 07:04:49 pm »
I can recommend this ebook by Thomas Kilian. It does not have all the answers to how the EA database/datamodel is structured, but it has helped me alot writing Custom SQL queries.

https://leanpub.com/InsideEA

Henrik Wivel