Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. X
Hello,
Does somebody know the link between an epmdocument and the secondary content (pvs) with oracle SQL?
Thanks in advance
Solved! Go to Solution.
This will get you the all the derived images an EPMDocument. If you want to see only the .pvs, you can uncomment the last line.
select a.*
from derivedimage i, epmdocument e, holdertocontent c, applicationdata a, epmdocumentmaster m
where m.cadname = '<name here>'
and m.ida2a2 = e.ida3masterreference
and i.ida3a6 = e.ida2a2
and c.ida3a5 = i.ida2a2
and c.ida3b5 = a.ida2a2
--and a.role = 'PRODUCT_VIEW_ED';
This will get you the all the derived images an EPMDocument. If you want to see only the .pvs, you can uncomment the last line.
select a.*
from derivedimage i, epmdocument e, holdertocontent c, applicationdata a, epmdocumentmaster m
where m.cadname = '<name here>'
and m.ida2a2 = e.ida3masterreference
and i.ida3a6 = e.ida2a2
and c.ida3a5 = i.ida2a2
and c.ida3b5 = a.ida2a2
--and a.role = 'PRODUCT_VIEW_ED';
Thanks Jamie,
This works great.
many thanks