Author Topic: [EA 15.2] Query request to extract created date and updated date  (Read 3957 times)

jack89

  • EA User
  • **
  • Posts: 49
  • Karma: +0/-1
    • View Profile
Hi all,

I need to extract from my model the created date and updated date for the following cases:

1) Each element of the model
2) Each Diagram of the model
3) Each element under package "X"

Anyone is able to provide me these query?

Thank you in advance


qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: [EA 15.2] Query request to extract created date and updated date
« Reply #1 on: June 08, 2021, 12:08:45 am »
SELECT CreatedDate, ModifiedDate FROM t_object
SELECT CreatedDate, ModifiedDate FROM t_diagram
SELECT CreatedDate, ModifiedDate FROM t_object WHERE packageID = <theId>

q.

jack89

  • EA User
  • **
  • Posts: 49
  • Karma: +0/-1
    • View Profile
Re: [EA 15.2] Query request to extract created date and updated date
« Reply #2 on: June 11, 2021, 10:05:32 pm »
Thank you, is it possible to extract the number of modification for each diagram?

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: [EA 15.2] Query request to extract created date and updated date
« Reply #3 on: June 11, 2021, 10:29:20 pm »
No, not really. You would need to make some sort of baseline comparison. And that's nor really funny. EA does have that functionality. But honestly, the effort to retrieve the actual change and especially their meaning is anything but a trivial task.

q.