sql link "modified by" and wtpart(master)

[rvanveerdeghem]

Hi,

Does somebody know in which table I can find the "modified by" for a wt.part.WTPart?

And maybe the link with the table wtpart or wtpartmaster?

Thanks in advance

kind regards

Ruben

[BenPerry · Accepted solution]

Ruben Vanveerdeghem‌,

It is surprising nobody has responded yet.  By now you have probably gotten your answer.  But if not, this might be helpful (for Oracle db query):

select
  m.wtpartnumber,
  p.VERSIONIDA2VERSIONINFO rev,
  p.ITERATIONIDA2ITERATIONINFO iteration,
  u.name modified_by,
  p.MODIFYSTAMPA2 last_modified
from
  wtpartmaster m,
  wtpart p,
  wtuser u
where 1=1
  and m.ida2a2 = p.IDA3MASTERREFERENCE
  and p.ida3b2iterationinfo = u.ida2a2
  and m.wtpartnumber = 'XYZ'
order by
  m.wtpartnumber,
  p.ida2a2
;