Query folders containing documents filtered by custom metada

hanumeshm — Wed, 02 Feb 2011 16:03:01 GMT

Hi, I am new to Alfresco.I am associating custom metadata 'targetUser' for the document while uploading. This is to specify who can access the document.Now user 'testUser' logins to application. Then I should display the folders which contain atleast one document whose custom metadata 'targetUser' m

Re: Query folders containing documents filtered by custom metada

hanumeshm — Wed, 02 Feb 2011 16:06:57 GMT

Forget to tell, I am using this logic in a Websript, and copying this module jar to Alfresco lib.

—————————————————————————
I tried this:

   I created aspects, attached metadata (targetUser) document while uploading, able to see the custom metadata in Alfresco explorer.
Writen a servlet code to retrieve documents filtered by custom metadata able to get only documents whose meta data 'targetUser' is say 'xyz'.

I have a custome websricpts module where I defined the customized webscripts, and copied this module to Alfresco
(<alfrescohome>\tomcat\webapps\alfresco\WEB-INF\lib) as a jar. One of the webscript is getting all folders under specified path.
Now I customized this webscript further so that I will get only the folders which contain documents related to a specific user.(by firing lucene query on metadata 'targetUser'). But after copying the latest jar to alfresco, giving error as ' No classDef Found: org/alfresco/webservice/repository/RepositoryFault'
I am using repository api for this logic so copied alfresco-web-service-client-3.3g.jar in the module which will be copied to alfresco.

Can anybody help me in resolving this issues please?
Thanks in advance,
Hanumesh
utility method which gives me required folders only follows:

import org.alfresco.service.cmr.model.FileFolderService;
import org.alfresco.service.cmr.model.FileInfo;
import org.alfresco.service.cmr.repository.NodeRef;
import org.alfresco.service.cmr.repository.StoreRef;
import org.alfresco.service.cmr.search.SearchService;
import org.alfresco.webservice.repository.QueryResult;
import org.alfresco.webservice.repository.RepositoryFault;
import org.alfresco.webservice.repository.RepositoryServiceSoapBindingStub;
import org.alfresco.webservice.types.NamedValue;
import org.alfresco.webservice.types.Query;
import org.alfresco.webservice.types.ResultSet;
import org.alfresco.webservice.types.ResultSetRow;
import org.alfresco.webservice.types.Store;
import org.alfresco.webservice.util.Constants;
import org.alfresco.webservice.util.WebServiceFactory;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
==================================
   ArrayList<String> getMyFolders(String userId, String userType){

      userId="honey";
      userType="Client User";

      RepositoryServiceSoapBindingStub repositoryService = WebServiceFactory.getRepositoryService();

      String ss = "TYPE:\"{http://www.alfresco.org/model/content/1.0}content\" AND @\\{locatable.targetUser\\}targetUser:honey*";
       Query query1 = new Query(Constants.QUERY_LANG_LUCENE,ss);
       Store storeRef = new Store(Constants.WORKSPACE_STORE, "SpacesStore");
          QueryResult queryResult=null;
      try {
         queryResult = repositoryService.query(storeRef, query1,false);
      } catch (RepositoryFault e) {
         // TODO Auto-generated catch block
         e.printStackTrace();
      } catch (RemoteException e) {
         // TODO Auto-generated catch block
         e.printStackTrace();
      }

          ResultSet resultSet = queryResult.getResultSet();

          long totalRowCount = resultSet.getTotalRowCount();
      System.out.println("Total count *****************"+totalRowCount);
         ResultSetRow[] rows = resultSet.getRows();

         DataLocation arrayLocation = new Paginator().calculateArrayLocation(rows.length, 1, rows.length);

      Set se=new HashSet();
      Set folderSet=new HashSet();
      ArrayList foldersList = new ArrayList();
        for (int i = arrayLocation.getStart() - 1; i < arrayLocation.getEnd(); i++) {
           System.out.println("—————————————————— Row: "+i);
                SearchResult sr = new SearchResult();
                sr.setSize(rows.length);
                //int docId = hitss.scoreDocs.doc;
                ResultSetRow row = rows;
                NamedValue[] columns = row.getColumns();

                for (int y = 0; y < columns.length; y++)
                {
                   System.out.println("***Metadata Name"+row.getColumns(y).getName());
                   System.out.println(" Value: "+row.getColumns(y).getValue());

                   if(row.getColumns(y).getName().endsWith("name"))
                    {
                      //sr.setSetpath(row.getColumns(y).getValue());
                       sr.setFilename(row.getColumns(y).getValue());
                      // ls.add(sr);

                    }
                   if(row.getColumns(y).getName().endsWith("path"))
                    {
                      sr.setSetpath(row.getColumns(y).getValue());
                      //get first level folders having documents only intended for user under root.
                      foldersList= FolderUtil.getFolderList(foldersList, row.getColumns(y).getValue());
                    }
                   se.add(sr);
                }
        }

        List list = new ArrayList(se);

/* For Testing Remove later */
        System.out.println("Folders to display====>"+foldersList.size());
        int i=0;
        if(foldersList!=null){
            while (foldersList.size()>0 && i<foldersList.size()){
               System.out.println("****"+foldersList.get(i));
               i++;
            }
        }
        //End
        long end=System.currentTimeMillis();
        return foldersList;

   }

topic Re: Query folders containing documents filtered by custom metada in Alfresco Archive

Query folders containing documents filtered by custom metada

Re: Query folders containing documents filtered by custom metada