AnsweredAssumed Answered

Querying the Alfresco repository (~DQL)

Question asked by bboeri on Jan 25, 2012
Latest reply on Jul 24, 2014 by paul.price
I understand that Alfresco has no document query language similar to Documentum's DQL.  Can anyone suggest a way to generate reports with the following kinds of information (assuming requisite permissions):

1) Get a complete count of all documents of a specific type
2) Get a complete count of all documents modified between two dates
3) The trickiest one: Get a report of all documents submitted to a workflow within a specific timeframe (e.g., via Activiti), so I could get a list of when each began and completed the workflow, so I could then generate stats such as "average time in the workflow" etc.

I suspect one possibility for 1and 2 would be appropriate Lucene queries, and then looking at a total count of results returned.  In Documentum, however, that wouldn't work because the search system (FAST, and maybe even Verity) returned a maximum result count of from 200-500 results, which in many cases would be far fewer than the possible search results.  Thus, at least for Documentum, the use of DQL.

Bob Boeri