topic Re: Querys through JAVA (SOLVED) in Alfresco Archive

Querys through JAVA (SOLVED)

rhakaro — Tue, 03 Nov 2009 19:58:33 GMT

Hello everyone, firstly, sorry for repeating theme if it is already asked. The problem is that I need to search from a Java program to Content in Alfresco. I must say that the only thing I have made are references to nodes, upload and download files.I've been all afternoon reading the wiki, this for

Re: Querys through JAVA (SOLVED)

jayjayecl — Wed, 04 Nov 2009 08:44:13 GMT

Didn't the examples here (http://wiki.alfresco.com/wiki/Search#Simple_Queries) help you ?

Re: Querys through JAVA (SOLVED)

rhakaro — Wed, 04 Nov 2009 12:10:11 GMT

Hi JayJayECL, thanks for ask me.

Yes, this wiki helps me writing querys with Lucene, but my problem is to bring it to my Java code.

Now I have this code:


RepositoryServiceSoapBindingStub repositoryService = WebServiceFactory.getRepositoryService();         
           
String searchText = "my_node_and_query_to_use_for_example";
         
// Create a query object, looking for all items with alfresco in the name of text
 Query query = new Query(Constants.QUERY_LANG_LUCENE, "PATH:\"/app:company_home/cm:" +searchText +"//*\"");
           
// Execute the query
final Store STORE = new Store(Constants.WORKSPACE_STORE, "SpacesStore");
 QueryResult queryResult = repositoryService.query(STORE, query, false);           
           
// Display the results
ResultSet results = queryResult.getResultSet();
ResultSetRow[] rows = results.getRows();
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

In "rows" I have all the Content, but now I don´t know how to access to information.

I read in this forum, someone who do something like:


for(ResultSetRow row : rows){
    ResultSetRowNode nodo = rows[i].getNode();
    String nodeId = row.getNode().getId();
    ContentResult contentResult = new ContentResult(nodeId);
    ….
    ….
}
‍‍‍‍‍‍‍‍‍

But I don´t know what is a "ContentResult"???? In eclipse, it seems to not be in the Alfresco libraries. What happend with that Object?? What pakage is from??

Thanks in advance.

Re: Querys through JAVA (SOLVED)

maqsood — Wed, 04 Nov 2009 12:24:09 GMT

rhakaro,

In "rows" I have all the Content, but now I don´t know how to access to information.

You can use the below code to access the row contents:

if (rows != null)
        {
            for (int x = 0; x < rows.length; x++)
            {
                ResultSetRow row = rows[x];
                
                NamedValue[] columns = row.getColumns();
                for (int y = 0; y < columns.length; y++)
                {
                    System.out.println("row " + x + ": "
                            + row.getColumns(y).getName() + " = "
                            + row.getColumns(y).getValue());
                }
            }
        }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Hope it helps you.

Re: Querys through JAVA (SOLVED)

rhakaro — Wed, 04 Nov 2009 14:49:05 GMT

Thank you very much, I was lost in all the possibles. I tried a code like this:


                        ResultSetRowNode nodo = rows[i].getNode();
              
              System.out.println("Type: " + nodo.getType());
              
              System.out.println("\tRecorrido de aspects:");
              String[] a = nodo.getAspects();
              for(int j=0; j<a.length; j++)
                 System.out.println("\t\t" + j + ": " +a[j]);
              
              System.out.println("\tIdentificador: " + nodo.getId());
              
              System.out.println("\tCampos typeDesc:");
              FieldDesc[] b = nodo.getTypeDesc().getFields();
              for(int z=0; z<b.length; z++)
                 System.out.println("\t\t" + z + b[z].getFieldName());
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

To see what was inside rows…

I was really blind with this.

Thank you!!