<?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 Help on CMIS Query using IN_TREE condition in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/help-on-cmis-query-using-in-tree-condition/m-p/300994#M254124</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Using Alfresco Community edition 5.0.d&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I am using CMIS 1.1 Atom Pub URL: &lt;/SPAN&gt;&lt;A href="http://test-alfresco:8080/alfresco/api/-default-/public/cmis/versions/1.1/atom" rel="nofollow noopener noreferrer"&gt;http://test-alfresco:8080/alfresco/api/-default-/public/cmis/versions/1.1/atom&lt;/A&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;My libraries&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;lt;code language="xml"&amp;gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;lt;dependency&amp;gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; &amp;lt;groupId&amp;gt;org.apache.chemistry.opencmis&amp;lt;/groupId&amp;gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; &amp;lt;artifactId&amp;gt;chemistry-opencmis-client-api&amp;lt;/artifactId&amp;gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; &amp;lt;version&amp;gt;0.13.0&amp;lt;/version&amp;gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;lt;/dependency&amp;gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;lt;dependency&amp;gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; &amp;lt;groupId&amp;gt;org.apache.chemistry.opencmis&amp;lt;/groupId&amp;gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; &amp;lt;artifactId&amp;gt;chemistry-opencmis-client-impl&amp;lt;/artifactId&amp;gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; &amp;lt;version&amp;gt;0.13.0&amp;lt;/version&amp;gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;lt;/dependency&amp;gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;lt;/code&amp;gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;In Alfresco Share, I verified the id of the folder. The folder that I am talking about is the &lt;/SPAN&gt;&lt;STRONG&gt;documentLibrary&lt;/STRONG&gt;&lt;SPAN&gt; folder under a specific site. On the documentLibrary folder, if I see view properties, or even if I see the browser URL, I see this below.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;A href="http://test-alfresco:8080/share/page/context/mine/folder-details?nodeRef=workspace://SpacesStore/6c3fd5c2-1a69-48a6-8d04-d39339ba53ec" rel="nofollow noopener noreferrer"&gt;http://test-alfresco:8080/share/page/context/mine/folder-details?nodeRef=workspace://SpacesStore/6c3fd5c2-1a69-48a6-8d04-d39339ba53ec&lt;/A&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Also, in my code using CMIS API, if I get the CmisObject of this documentLibrary folder, it has this id &lt;/SPAN&gt;&lt;STRONG&gt;6c3fd5c2-1a69-48a6-8d04-d39339ba53ec&lt;/STRONG&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Using the Share App, I see all the documents under this folder, but under some sub folders.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;However, if I construct my query using the above id with the IN_TREE clause, I do not get these documents (images) in the results.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;I tried &lt;/SPAN&gt;&lt;STRONG&gt;CMIS workbench&lt;/STRONG&gt;&lt;SPAN&gt; to cross check. I am glad it behaves the same way as my code.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;My CMIS workbench query is&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;lt;code language="sql"&amp;gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;SELECT doc.*, salo.* FROM cmis:document AS doc JOIN salo:documentProperties AS salo ON doc.cmis&lt;img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" /&gt;bjectId = salo.cmis&lt;img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" /&gt;bjectId&amp;nbsp; &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;WHERE IN_TREE(doc, 'workspace://SpacesStore/6c3fd5c2-1a69-48a6-8d04-d39339ba53ec')&amp;nbsp; &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;AND (salo.salo:lo_key = 163) AND (salo.salo:lo_category = 'Test')&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;lt;/code&amp;gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;If I remove the IN_TREE clause, query brings all the documents. All these documents are under one of the folders under this &lt;/SPAN&gt;&lt;STRONG&gt;documentLibrary&lt;/STRONG&gt;&lt;SPAN&gt; folder. I verified this using Alfresco Share. &lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Appreciate your help&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Tue, 14 Jun 2016 19:14:07 GMT</pubDate>
    <dc:creator>sepgs2004</dc:creator>
    <dc:date>2016-06-14T19:14:07Z</dc:date>
    <item>
      <title>Help on CMIS Query using IN_TREE condition</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/help-on-cmis-query-using-in-tree-condition/m-p/300994#M254124</link>
      <description>Using Alfresco Community edition 5.0.dI am using CMIS 1.1 Atom Pub URL: http://test-alfresco:8080/alfresco/api/-default-/public/cmis/versions/1.1/atomMy libraries&amp;lt;code language="xml"&amp;gt;&amp;lt;dependency&amp;gt; &amp;lt;groupId&amp;gt;org.apache.chemistry.opencmis&amp;lt;/groupId&amp;gt; &amp;lt;artifactId&amp;gt;chemistry-ope</description>
      <pubDate>Tue, 14 Jun 2016 19:14:07 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/help-on-cmis-query-using-in-tree-condition/m-p/300994#M254124</guid>
      <dc:creator>sepgs2004</dc:creator>
      <dc:date>2016-06-14T19:14:07Z</dc:date>
    </item>
    <item>
      <title>Re: Help on CMIS Query using IN_TREE condition</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/help-on-cmis-query-using-in-tree-condition/m-p/300995#M254125</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;If you see my query above, I have used &lt;/SPAN&gt;&lt;STRONG&gt;doc&lt;/STRONG&gt;&lt;SPAN&gt;, which is an alias for the cmis:document, in this IN_TREE qualifier for a folder id. Is this correct? I believe so.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;The problem is, it works sometimes, and does not work the other times. &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Suppose the folder contains 10 documents, Alfresco Share would show all 10 of them. However, this retrieval gets only few of them and not all the 10 documents that are under this folder whose id is passed into the IN_TREE condition.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;STRONG&gt; What is this qualifier really represent? &lt;/STRONG&gt;&lt;BR /&gt;&lt;STRONG&gt; What is the relationship between this qualifier and the id in the IN_TREE(qualifier, id) condition? &lt;/STRONG&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;It looks like, what I am giving is correct.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;This is what is mentioned about the qualifier in this site &amp;lt;url&amp;gt;&lt;/SPAN&gt;&lt;A href="https://wiki.alfresco.com/wiki/CMIS_Query_Language" rel="nofollow noopener noreferrer"&gt;https://wiki.alfresco.com/wiki/CMIS_Query_Language&lt;/A&gt;&lt;SPAN&gt;&amp;lt;/url&amp;gt; under the Contains section.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;lt;cite&amp;gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;The qualifier, if provided, must be the name or alias of one of the tables in the FROM clause. The full text search expression should then only match objects of this type. A qualifier must be provided if there is any ambiguity as to which object a full text search expression should match - i.e. there is a JOIN. &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;lt;/cite&amp;gt;&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Please help!&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 22 Jun 2016 21:54:00 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/help-on-cmis-query-using-in-tree-condition/m-p/300995#M254125</guid>
      <dc:creator>sepgs2004</dc:creator>
      <dc:date>2016-06-22T21:54:00Z</dc:date>
    </item>
  </channel>
</rss>

