Author Topic: Where are milestones from resource allocation stored in the database  (Read 155 times)

Luigi2021

  • EA User
  • **
  • Posts: 33
  • Karma: +0/-0
    • View Profile
Hi,

Where in the database is the value stored that is set in the milestones property in the assign resource editor?

Thanks in advance!

Kind regards,

Luigi

qwerty

  • EA Guru
  • *****
  • Posts: 12819
  • Karma: +366/-295
  • I'm no guru at all
    • View Profile
Re: Where are milestones from resource allocation stored in the database
« Reply #1 on: July 13, 2022, 05:38:30 pm »
Actually I have no idea, but I'd first search in t_xref and then t_document. Simple watch for db changes when adding a milestone. I'd do that but I'm really busy with other things like re-building my terrace.

q.

Luigi2021

  • EA User
  • **
  • Posts: 33
  • Karma: +0/-0
    • View Profile
Re: Where are milestones from resource allocation stored in the database
« Reply #2 on: July 13, 2022, 08:06:12 pm »
I've found it. It's in the t_xref table, the type must be t_objectresource and the "Supplier" contains the milestone's guid.

Thanks for your help and good luck with your terrace.