topic help with a lucene query in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/help-with-a-lucene-query/m-p/61217#M37965 <HTML><HEAD></HEAD><BODY><SPAN>I have the following code </SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />public void testSearchAPI() {<BR /><BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; try {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AuthenticationUtils.startSession(USERNAME, PASSWORD);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } catch (AuthenticationFault authenticationFault) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; authenticationFault.printStackTrace();&nbsp; //To change body of catch statement use File | Settings | File Templates.<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR /><BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Query query = new Query(Constants.QUERY_LANG_LUCENE, "TEXT:Da*");<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RepositoryServiceSoapBindingStub repositoryService = WebServiceFactory.getRepositoryService();<BR /><BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; try {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; QueryResult queryResult = repositoryService.query(STORE, query, true);<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Assert.assertNotNull("queryResult should not be null", queryResult);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String querySession = queryResult.getQuerySession();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Assert.assertNotNull("querySession should not be null", querySession);<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ResultSet resultSet = queryResult.getResultSet();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Assert.assertNotNull("The result set should not be null", resultSet);<BR /><BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.out.println("number of results" + resultSet.getRows().length);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ContentServiceSoapBindingStub contentService = WebServiceFactory.getContentService();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; int i=0;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for (ResultSetRow row : resultSet.getRows()) {<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Reference ref = new Reference();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ref.setUuid(row.getNode().getId());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ref.setStore(STORE);<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Read the newly added content from the respository<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Content[] readResult = new Content[0];<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; try {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; readResult = contentService.read(new Predicate(new Reference[]{ref}, STORE, null), Constants.PROP_CONTENT);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } catch (RemoteException e) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; e.printStackTrace();&nbsp; //To change body of catch statement use File | Settings | File Templates.<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Content content = readResult[0];<BR /><BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.out.println("content url " + content.getUrl());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ContentFormat format =content.getFormat();<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.out.println("format is"+format.getMimetype());<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(format.getMimetype().equals("application/pdf")){<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ContentUtils.copyContentToFile(content, new File("/home/dcrossma/Desktop/doc"+ ++i +".pdf"));<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row.getNode().<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR /><BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } catch (RemoteException e) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; e.printStackTrace();&nbsp; //To change body of catch statement use File | Settings | File Templates.<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } finally {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // End the session<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AuthenticationUtils.endSession();<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR /><BR /><BR />&nbsp;&nbsp;&nbsp; }<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>In my repository i have created some custom metadata fields eg csg<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />roponent&nbsp; I would like to search for all spaces that have this field with a value say Dave. </SPAN><BR /><BR /><SPAN>Is this possible ???? I have never queried with lucene before so i am struggling a little <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></SPAN></BODY></HTML> Thu, 01 Mar 2007 03:58:48 GMT dcrossma 2007-03-01T03:58:48Z help with a lucene query https://connect.hyland.com/t5/alfresco-archive/help-with-a-lucene-query/m-p/61217#M37965 I have the following code public void testSearchAPI() {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; try {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AuthenticationUtils.startSession(USERNAME, PASSWORD);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } catch (AuthenticationFault authenticationFault) {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; authenticationFault.printStackTrace();&nbsp; //To change body of catch statement use File | Settings Thu, 01 Mar 2007 03:58:48 GMT https://connect.hyland.com/t5/alfresco-archive/help-with-a-lucene-query/m-p/61217#M37965 dcrossma 2007-03-01T03:58:48Z Re: help with a lucene query https://connect.hyland.com/t5/alfresco-archive/help-with-a-lucene-query/m-p/61218#M37966 <HTML><HEAD></HEAD><BODY><SPAN>The following query game me what I wanted </SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>Query query = new Query(Constants.QUERY_LANG_LUCENE, "+@\\{csg.model\\}proponent:\"test\" AND (TYPE:\"{<A href="http://www.alfresco.org/model/content/1.0}folder\" rel="nofollow noopener noreferrer">http://www.alfresco.org/model/content/1.0}folder\</A>")");<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Thu, 01 Mar 2007 06:24:42 GMT https://connect.hyland.com/t5/alfresco-archive/help-with-a-lucene-query/m-p/61218#M37966 dcrossma 2007-03-01T06:24:42Z Re: help with a lucene query https://connect.hyland.com/t5/alfresco-archive/help-with-a-lucene-query/m-p/61219#M37967 <HTML><HEAD></HEAD><BODY><SPAN>Hi!</SPAN><BR /><SPAN>The code</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />String strQuery= "+@{cice.salaprensa.model}fuente:Load";<BR />Query query = new Query(Constants.QUERY_LANG_LUCENE, strQuery);<BR />QueryResult rootChildren = repositoryService.query(STORE, query, true);<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>thows me this:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR /><BR />AxisFault<BR /> faultCode: {<A href="http://schemas.xmlsoap.org/soap/envelope/}Server.generalException" rel="nofollow noopener noreferrer">http://schemas.xmlsoap.org/soap/envelope/}Server.generalException</A><BR /> faultSubcode: <BR /> faultString: <BR /> faultActor: <BR /> faultNode: <BR /> faultDetail: <BR />&nbsp;&nbsp;&nbsp;{<A href="http://www.alfresco.org/ws/service/repository/1.0}RepositoryFault" rel="nofollow noopener noreferrer">http://www.alfresco.org/ws/service/repository/1.0}RepositoryFault</A>:&lt;ns1:errorCode&gt;0&lt;/ns1:errorCode&gt;&lt;ns1:message&gt;Failed to parse query: +@{cice.salaprensa.model}fuente:Load&lt;/ns1:message&gt;<BR />&nbsp;&nbsp;&nbsp;{<A href="http://xml.apache.org/axis/}exceptionName:org.alfresco.repo.webservice.repository.RepositoryFault" rel="nofollow noopener noreferrer">http://xml.apache.org/axis/}exceptionName:org.alfresco.repo.webservice.repository.RepositoryFault</A><BR />&nbsp;&nbsp;&nbsp;{<A href="http://xml.apache.org/axis/}stackTrace" rel="nofollow noopener noreferrer">http://xml.apache.org/axis/}stackTrace</A>:<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.webservice.repository.RepositoryWebService.query(RepositoryWebService.java:233)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor612.invoke(Unknown Source)<BR /><BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>I repeat: </SPAN><STRONG>Failed to parse query: +@{cice.salaprensa.model}fuente:Load</STRONG><SPAN> </SPAN><BR /><BR /><SPAN>What I'm doing wrong???!!!</SPAN><BR /><SPAN> <img id="smileysad" class="emoticon emoticon-smileysad" src="https://connect.hyland.com/i/smilies/16x16_smiley-sad.png" alt="Smiley Sad" title="Smiley Sad" />&nbsp; <img id="smileysad" class="emoticon emoticon-smileysad" src="https://connect.hyland.com/i/smilies/16x16_smiley-sad.png" alt="Smiley Sad" title="Smiley Sad" /></SPAN></BODY></HTML> Fri, 08 Jun 2007 08:56:30 GMT https://connect.hyland.com/t5/alfresco-archive/help-with-a-lucene-query/m-p/61219#M37967 putodemonio 2007-06-08T08:56:30Z