<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic more question about query in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/more-question-about-query/m-p/30201#M15494</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;I built their web service client jar with updated url.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Created a project. Created a web service client based on there samples.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Added WSS4J, AXIS, XML Security lib, openSAML to the project.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Did a query using:&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;RepositoryServiceSoapBindingStub repositoryService = WebServiceFactory.getRepositoryService();&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; // searchValue=/cm:Test/cm:Test2/cm:jbivision.pdf&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Query query = new Query(QueryLanguageEnum.lucene, "PATH:\"/" + searchValue + "\"");&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; // Query query = new Query(QueryLanguageEnum.lucene, "PATH:\"//.\""); &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; QueryResult queryResult = repositoryService.query(STORE, query, true); &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; //query = null; //Result = repositoryService.query(STORE, query, true); &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ResultSet result = queryResult.getResultSet();&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; uri = result.getRows(0).getColumns(10).getValue();&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;It returned me only one result, seems this works..&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;What I am not clear is:&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;1) I used cm:/Test/cm:Test2 to represent /Test/Test2 directory, is this correct?&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;2) From the debugger, I saw queryResult Row0 Column10: source is the same as the location I get:&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;WorkSpace://SpacesStore/…..&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;is this the right one? How do I get the full URI path based on this?&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;3) I also noticed there is a contentUrl in Column4, is it something we need for the URI? Based on my observation, its value is different from the&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;file location.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks.&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 29 Mar 2006 04:21:11 GMT</pubDate>
    <dc:creator>qoszhao</dc:creator>
    <dc:date>2006-03-29T04:21:11Z</dc:date>
    <item>
      <title>more question about query</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/more-question-about-query/m-p/30201#M15494</link>
      <description>I built their web service client jar with updated url.Created a project. Created a web service client based on there samples.Added WSS4J, AXIS, XML Security lib, openSAML to the project.Did a query using: RepositoryServiceSoapBindingStub repositoryService = WebServiceFactory.getRepositoryService();&amp;nbsp;</description>
      <pubDate>Wed, 29 Mar 2006 04:21:11 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/more-question-about-query/m-p/30201#M15494</guid>
      <dc:creator>qoszhao</dc:creator>
      <dc:date>2006-03-29T04:21:11Z</dc:date>
    </item>
    <item>
      <title>Re: more question about query</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/more-question-about-query/m-p/30202#M15495</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hi,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I'll try and answer your questions for you …&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;1)&amp;nbsp; Yes the path cm:Test/cm:Test2 is correct.&amp;nbsp; All names in an XPath must be qualified by their namespace or well known prefix.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;2)&amp;nbsp; I'm not entirly sure what you are asking here, but a property with a value Workspace://SpacesStore/1231-123-123 is the string representation of a node reference.&amp;nbsp; A node reference is how the server side API uniquely references a node.&amp;nbsp; It is like a Reference in web services.&amp;nbsp; The first part is the store protocol, the second the store identifier and the last the GUID of the node.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;3)&amp;nbsp; Yes the URI you have spotted points to the download servlet and when issued will return the content of the node in question.&amp;nbsp; Look in ContentUtils.java in the web service client project for guidance on how to use this.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Hope this helps,&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Roy&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 04 Apr 2006 13:07:18 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/more-question-about-query/m-p/30202#M15495</guid>
      <dc:creator>rwetherall</dc:creator>
      <dc:date>2006-04-04T13:07:18Z</dc:date>
    </item>
    <item>
      <title>Re: more question about query</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/more-question-about-query/m-p/30203#M15496</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Thanks a lot Roy!&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 04 Apr 2006 13:12:19 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/more-question-about-query/m-p/30203#M15496</guid>
      <dc:creator>qoszhao</dc:creator>
      <dc:date>2006-04-04T13:12:19Z</dc:date>
    </item>
  </channel>
</rss>

