Community Tip - Stay updated on what is happening on the PTC Community by subscribing to PTC Community Announcements. X
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
Solved! Go to Solution.
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
;
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
;