Skip to main content
12-Amethyst
Sep 23, 2016 11:14 AM UTC
Solved

sql link "modified by" and wtpart(master)

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
BenPerryAnswer
15-Moonstone
Dec 23, 2016 2:18 PM UTC

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
Dec 23, 2016 2:18 PM UTC

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

;

Translate