We have an existing portal where maximum number of versions to keep was set to 20 at the highest level. This portal has a lot of sync folders and content. Now we want to change the maximum number of versions to keep to 1 globally. I did that under the Admin menu, however I noticed that some documents still have more than 1 version. When I check the table DMX_Entries, a lot of the entries still have versionstokeep set to a value other than 1 and a lot of the entries have that set to null. Is there an easy to update all the entries to just keep 1 version? Do I need to update it from the back-end by updating the field versionstokeep in DMX_Entries table or is there a better way of handling this? Please davise.

Thanks,
Chhavi

Hi Chhavi,

Just change the value in the DMX_Entries table for all those entries. That's the easiest and fastest. You may want to disable the triggers on the DMX_Entries table temporarily while you do this if you're running an older version of DMX (pre 5.3).

Peter

Thanks Peter. Does it hurt if I update ALL rows in DMX_Entries table for this portal to be 1?

Chhavi

Not at all. But keep in mind that the cleanup only happens when someone uploads a new version. The maintenance task does not get rid of old versions.

Peter

Thanks for the clarification Peter.