epmdocument + secondary content (pvs) sql

[rvanveerdeghem]

Hello,

Does somebody know the link between an epmdocument and the secondary content (pvs) with oracle SQL?

Thanks in advance

[jmomber · Accepted 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';

[rvanveerdeghem]

Thanks Jamie,

This works great.

many thanks