Solved
How can I get a list of documents that don't have renditions?
Posted on 2008-10-07
Software: EMC Documentum 5.3 SP3 running on Microsoft Windows Server 2003 and Oracle 10g.
Within Documentum, how can I query to find documents that don't have renditions.
When I do a dump on a document object (dump,c,r_object_id), I don't see any attribute that relates to a rendition. I dumped before and after a given object had a rendition, and saw no changes in the attributes (except for r_modify_date).
Using DQL, I've also reviewed the dmr_content table, and have created a nested query that gets me pretty close. (select r_object_id from dm_document where r_object_id in (select distinct parent_id from dmr_content where rendition <> 2)
The last part of that DQL query, the "<> 2" implies give me all documents that don't have a PDF rendition (or at least that's what I thought it should do).
If I do "=2" it returns documents that do have PDF renditions. However, if I do "<> 2" it gives me all documents with and without PDF renditions.
I may not be understanding the rendition attribute found in the dmr_content table and how it's used, which is why my query is failing.
Ultimately, I would like to be able to auto-queue a random group of documents that I know to be missing renditions due to a bug.
I would like to query to find the object IDs of all documents without PDF Renditions, and then queue these documents. Can anyone help me isolate this query?
Does the queuing part need to be done using DFC, or can it be in a more lightweight fashion (perhaps DQL?)
Thanks,
Lane