Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! 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
;