Script to delete PDF rendition from 800 document

ecm_newer

Hi all,

Can someone helps me to make a Script to delete PDF rendition from 800 documents in documentum.

I already extract in .CSV the r_object_id of each pdf redition and the parent_id (The r_oject_id of the nativ  word document).

I have created and tested an dql query to just delete one:

eg: delete dmr_content objects where r_object_id='xxxxxxxxxxxxxxxxxxxx';

Please advise

DCTM_Guru

How are you getting list of r_object_ids?  If by DQL query, then you should be able to combine the two:

delete dmr_content objects where r_object_id in (select r_object_id from ...)