Hi Peter,

If a DMX install started out with the "Number of versions set to the default of -1 (keep all), and later was changed to "1", what is the easiest way to delete all of the old versions so they do not show up in searches?

Thanks,

Rob Ralston

Hi Peter,

I tried this procedure, and it worked, however I want to point out two observations:

When I edited the attributes of an item with two versions, the number of versions to keep was still set to "-1", which I assume is by design, since that was the original default value. So I changed it to "1" and clicked Finish (I changed nothing else).

When the item was refreshed, it now had a new Modified Date in the Grid View and in the Versions section of the Details pane. In other words, it appears as if I had actually modified the file somehow, rather than just changing the number of versions to keep. Not sure if this is by design, since it provides very misleading data, IMO.

I also suspect it would cause a subscription email to go out, which would be very confusing.

Can you recommend a more "behind the scenes" approach to changing this and eliminating the old versions. I guess I am asking you for a SQL Script.

Thank you,

Rob Ralston

Hi Peter,

On the dates, what confused me is both dates became the same after I went through the procedure of changing the number of versions to keep meta data for the file.

BTW, would this have caused a subscribed email to go out?

On asking for the SQL script I certainly did overlook the need to delete the physical file. Thanks for considering another method.

Rob