Document counts from Spaces

[schmidtster]

Has anybody  run mysql database queries in alfresco backend to find the number of documents under a particluar Space/folder? or found other ways to get document counts in Alfresco? Thanks for your help Steve

[zomurn]

Below, the code I use for this :

/**    * number of documents having parent's folder as pSrcNodeRef and of type pType<br>    *     * @param pType    *            Type de document à retourner    * @param pSrcNodeRef    *            Dossier source où sont les documents    * @return number of doc. in pSrcFolder of type pType    */   public Integer getDocumentListCount(QName pType, NodeRef pSrcNodeRef) {      MscValidateUtil.validateNotNull( pType );      MscValidateUtil.validateNotNull( pSrcNodeRef );      MscValidateUtil.validate( Arrays.asList( pSrcNodeRef ),            ContentModel.TYPE_FOLDER, nodeService );      String lSrcFolderName = (String) nodeService.getProperty( pSrcNodeRef,            ContentModel.PROP_NAME );      ResultSet lResultSet = searchService.query(            MscStoreEnum.WORKSPACE_SPACES_STORE.getStoreRef(),            SearchService.LANGUAGE_LUCENE, "+PATH:\"/app:company_home/cm:"                  + lSrcFolderName + "/*\"" + " +TYPE:\"" + pType + "\"" );      lResultSet.getResultSetMetaData().getSearchParameters().setLimitBy(            LimitBy.UNLIMITED );      return lResultSet.length();   }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

You need to use lucene query for this