topic How to find total number of document uploaded in repository? in Alfresco Archive

How to find total number of document uploaded in repository?

dynamolalit — Wed, 26 May 2010 12:32:12 GMT

Hi,Is there any way i can get total number of content documents uploaded in Alfresco repository by all existing users.I found one db query but it does not seem to give correct ouptut.SELECT count(*) FROM alfresco.alf_node a where type_qname_id=35;where 35 is id for content in alfresco.alf_qname tabl

Re: How to find total number of document uploaded in repository?

ivan_plestina — Sat, 29 May 2010 14:08:19 GMT

Best way is the one you have tried. You might get incorrect results because of deleted content. So limit your query to workspacepacesStore e.g. AND store_id=<id>.

Re: How to find total number of document uploaded in repository?

dynamolalit — Tue, 01 Jun 2010 11:07:43 GMT

Hi Ivan,

Thanks for your help.

Below is updated query to get all content for "workspace:spacestore" :

SELECT count(*) FROM alfresco.alf_node a where type_qname_id=35 and store_id=6;

Re: How to find total number of document uploaded in repository?

dynamolalit — Mon, 07 Jun 2010 04:28:19 GMT

Hi,

I used a webscript to get total number of content in repository as DB thingy was not accurate all the times. :?:

Here is the code for same:

var contentDocs = search.luceneSearch("TYPE:\"{http://www.alfresco.org/model/content/1.0}content\"");
var totalCnt = contentDocs.length;

To get it rendered , i used model array variable in ftl:

model.allContent = totalCnt ;

Re: How to find total number of document uploaded in repository?

chapeaurouge — Fri, 20 Aug 2010 14:56:20 GMT

Didn't you run in the 1000 limit with the webscript?

I have over 100,000 documents, but unless I change system.acl.maxPermissionChecks and system.acl.maxPermissionCheckTimeMillis to higher numbers, there is apparently no way.

I read another post where, in java, one could use a fetchSize() method to split the resultSet, but I don't know how to do it in javascript.. If anyone has insights.

Anyways, for a repository that gets really large, it may just take too long to return. I have also written a database stored procedure to get the total number of documents, by types.

Re: How to find total number of document uploaded in repository?

themarcuz — Wed, 01 Sep 2010 10:11:51 GMT

Hi all,
I'm trying to do quite the same thing, but I have to retrieve the number of content's uploaded per user.
The direct db query seems interesting, but where could you do that? You have to write your java code and access directly to the db, or you can use some kind of Alfresco API that support sql queries?

Re: How to find total number of document uploaded in repository?

chapeaurouge — Wed, 01 Sep 2010 10:12:57 GMT

You can write a webscript which, instead of using a javascript, uses a traditional java class (java backed web script)

Re: How to find total number of document uploaded in repository?

chapeaurouge — Wed, 01 Sep 2010 10:14:12 GMT

I have posted a couple things in my blog

http://ironman.darthgibus.net/?cat=23

But I haven't written the webscript yet.