Skip to main content
12-Amethyst
Jun 11, 2016 5:06 AM UTC
Solved

epmdocument + secondary content (pvs) sql

Hello,

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

Thanks in advance

jmomberAnswer
12-Amethyst
Jun 14, 2016 7:14 PM UTC

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';

2 replies

jmomber12-AmethystAnswer
12-Amethyst
Jun 14, 2016 7:14 PM UTC

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';

Translate
12-Amethyst
Jun 15, 2016 7:29 AM UTC

Thanks Jamie,

This works great.

many thanks

Translate