To find the path to the contents file of a rendition of a document, issue the following query from the dql editor. The example query below locates the contents for the pdf rendition of a file named ‘Original’. To find other types of renditions, insert the appropriate format into this query.

select r_object_id as the_id from dmr_content where any i_rendition !=0 and format in (select r_object_id from dm_format where name=’pdf’) and any parent_id in (select r_object_id from dm_document where object_name=’Original’)

You can then find the path to this object by issuing the following API commands:

apply,c,<r_object_id returned above>,GET_PATH
next,c,q0
get,c,q0,result

This article is from PowerLink.