Query for versions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-14-2020 04:42 AM
Hi,
what query should i do to extract documents witch have the highest number of versions (more than 100)
- Labels:
-
Alfresco Content Services
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-17-2020 05:56 AM
Hi @liluth,
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,
Problem solved? Click Accept as Solution!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-18-2020 12:21 PM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-19-2020 04:28 AM
ContentStore : 1.93 To 3 605 447 Files
