DCTM:DQL:Renditions

Objects that have requested a rendition but no rendition is present

select count(i_rendition),t1.r_object_id from dmr_content_rp t,dm_sysobject_sp t1 where t1.a_content_type='pdf' and t1.r_object_id = t.parent_id group by t1.r_object_id having count(i_rendition) < 2

Leave a Reply

Your email address will not be published.