topic Re: Query for versions in Alfresco Forum

Query for versions

liluth — Sat, 14 Mar 2020 08:42:04 GMT

Hi,

what query should i do to extract documents witch have the highest number of versions (more than 100)

Re: Query for versions

EddieMay — Tue, 17 Mar 2020 09:56:03 GMT

Could you give a little more background about why and how you plan to use this query? Also, how big is your content store? How often will you run this query? Is this an ad hoc admin query or part of a reporting requirement, that would be run regularly?

Thanks,

Re: Query for versions

liluth — Wed, 18 Mar 2020 16:21:58 GMT

Hi,

we plan to run it manually once a month. The goal is to lighten the content store and reduce the response time. We can remove minus version. For the weight, i give an answer tomorrow

Bye

Re: Query for versions

liluth — Thu, 19 Mar 2020 08:28:13 GMT

ContentStore : 1.93 To 3 605 447 Files