Problems about searching with Lucene/Xpath

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

camillo

Hi all,

I have an xml file stored into a space and i would like perform some searches from my web-client.
In spite of this, I read http://wiki.alfresco.com/wiki/Search_Documentation but I have some problems about understanding the way that allows me to search informations I need.
For example, if my xml file, named pets.xml, is:

<INFO>
&nbsp; <ANIMALS>
&nbsp;&nbsp;&nbsp;<ANIMAL>
&nbsp;&nbsp;&nbsp;&nbsp; <NAME>CAT</NOME>
&nbsp;&nbsp;&nbsp;&nbsp; <COLOR>BLACK</COLOR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </ANIMAL>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <ANIMAL>
&nbsp;&nbsp;&nbsp;&nbsp; <NAME>DOG</NOME>&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp; <COLOR>BROWN</COLOR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </ANIMAL>
&nbsp; <ANIMALS>
</INFO>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍

what's the query I must set to found the color of the dog?
I perform this query using this code:

 RepositoryServiceSoapBindingStub repositoryService = WebServiceFactory.getRepositoryService();
 String path = "PATH:\"/app:company_home/cm:ZOO/cm:INFO/cm:pets.xml\" AND  TEXT:\"DOG*\"";
 Query query = new Query(Constants.QUERY_LANG_LUCENE, path);
 Store STORE = new Store(Constants.WORKSPACE_STORE, "SpacesStore");
 QueryResult queryResult;
queryResult = repositoryService.query(STORE, query, false);
org.alfresco.webservice.types.ResultSet resultSet = queryResult.getResultSet();
org.alfresco.webservice.types.ResultSetRow[] rows = resultSet.getRows();
‍‍‍‍‍‍‍‍‍‍

but it doesn't work!!!!!!
Please, help me….I'm crazying!
Thanks in advance!

openpj

You must encode all the names of the spaces in your query with an ISO9075 encoding class:

org.alfresco.webservice.util.ISO9075‍

in the following way:

String path = "PATH:\"/app:company_home/cm:"+ISO9075.encode("ZOO")+"/cm:"+ISO9075.encode("INFO")+"/cm\:name:pets.xml\" AND  TEXT:\"DOG*\"";
‍‍‍

In your query I think that you needed to add name property in your last condition of the query with cm\:name.

Hope this helps.