cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Stay updated on what is happening on the PTC Community by subscribing to PTC Community Announcements. X

sql link "modified by" and wtpart(master)

rvanveerdeghem
10-Marble

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

ACCEPTED SOLUTION

Accepted Solutions

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

;

View solution in original post

1 REPLY 1

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

;

Announcements


Top Tags