mscann

Need to Verify .xml Code for a Customized Job:  Purge Document Job

Discussion created by mscann on Sep 6, 2012
Latest reply on Sep 10, 2012 by Chris_Hackett
Hello,

I'm looking to confirm if the code that I'm using and the placement of the Codeto customize the Purge Document Job’s is correct?

I need the Job to do the following criteria:
1. Delete the Documents that have a newer version, and
2. Delete the Documents that have not been updated ("last_updated_date) before 9/1/2011.

The .xml file for the OOTB Job is attached. Can someone provide me with where I should put the following "last_update_by" statement:

Here is my attempt:
# <text>SELECT id FROM CLB_DMS_VERSIONS WHERE purge = 1 and is_latest <> 1</text>
</sql>
<text>Select id FROM CLB_DMS_VERSIONS where trunc(last_updated_date) < '2011-07-01' and is_latest = 0
</statement>
- <statementSet id="dms.purge.getDocumentsToBePurged" databaseId="Niku">
<statementRef id="dms.purge.getDocumentsToBePurged" inputSource="map" />
</statementSet>
- <statement id="dms.purge.getDocumentsToBePurged">
- <sql>
<text>SELECT id FROM CLB_DMS_FILES WHERE purge = 1</text>
</sql>
</statement>


I'm replacing <text>SELECT id FROM CLB_DMS_VERSIONS WHERE purge = 1 and is_latest <> 1</text>
</sql>

With: <text>Select id FROM CLB_DMS_VERSIONS where trunc(last_updated_date) < '2011-07-01' and is_latest = 0<text>

Thanks!

Attachments

Outcomes