Skip to main content
R
rvanveerdeghem12-Amethyst
12-Amethyst
September 23, 2016
Solved

sql link "modified by" and wtpart(master)

  • September 23, 2016
  • 1 reply
  • 1342 views

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

Best answer by BenPerry

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


;

1 reply

BenPerry
BenPerry15-MoonstoneAnswer
15-Moonstone
December 23, 2016

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


;
Terms & ConditionsAccessibility statement