Script to delete PDF rendition from 800 document

Options
ecm_newer
ecm_newer
edited August 7, 2009 in Documentum #1

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

Tagged:

Comments

  • DCTM_Guru
    DCTM_Guru
    edited August 7, 2009 #2
    Options

    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 ...)

  • ecm_newer
    ecm_newer
    edited August 7, 2009 #3
    Options

    Thanks a lot Johnny Gee

Categories