(private) sorry...!! contact@ecmnotes.com

Renditions

Display all objects that have renditions:

SELECT r_object_id, object_name, a_content_type, r_object_type,r_lock_owner, r_link_cnt FROM dm_document WHERE r_object_id IN (SELECT parent_id FROM dmr_content WHERE rendition > 0)

Display all of objects that have PDF renditions:

SELECT r_object_id, object_name, a_content_type, r_object_type,r_lock_owner, r_link_cnt FROM dm_document WHERE r_object_id IN (SELECT parent_id FROM dmr_content WHERE full_format='pdf’ and rendition > 0) and owner_name = USER

Leave a Reply