topic Re: CMIS Query with IN_TREE in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/cmis-query-with-in-tree/m-p/46710#M18559 <HTML><HEAD></HEAD><BODY><P>The question&nbsp;then would be, "why" can't you combine more than one IN_TREE clause? Is this some hard-coded implementation of Alfresco that limits this? Because conceptually, it feels like one should be able to do something like this, since content items in CMIS are allowed to be multi-filed, and by combinding two IN_TREE&nbsp;clauses you could filter results to find only those that actually are multi-filed.</P></BODY></HTML> Mon, 11 Mar 2019 21:24:24 GMT afaust 2019-03-11T21:24:24Z CMIS Query with IN_TREE https://connect.hyland.com/t5/alfresco-forum/cmis-query-with-in-tree/m-p/46708#M18557 Good day.I don't understand why my query doesn't work, when I use several IN_TREE<IMG id="smileyfrustrated" class="emoticon emoticon-smileyfrustrated" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-frustrated.png" alt="Smiley Frustrated" title="Smiley Frustrated" />ELECT * from cmis:document WHERE IN_TREE('cb51f2f8-5ed1-49f6-a231-356c3b40c6d1') AND IN_TREE('cecbca1b-c59c-4629-b8c0-0bdbc26fdf46')If I use only one IN_TREE, like<IMG id="smileyfrustrated" class="emoticon emoticon-smileyfrustrated" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-frustrated.png" alt="Smiley Frustrated" title="Smiley Frustrated" />ELECT * from cmis:document WHERE IN_TREE('cb51f2f8-5 Mon, 11 Mar 2019 10:02:31 GMT https://connect.hyland.com/t5/alfresco-forum/cmis-query-with-in-tree/m-p/46708#M18557 viktoriyamoskov 2019-03-11T10:02:31Z Re: CMIS Query with IN_TREE https://connect.hyland.com/t5/alfresco-forum/cmis-query-with-in-tree/m-p/46709#M18558 <HTML><HEAD></HEAD><BODY><P>You cannot combine more than one IN_TREE clause in your WHERE.</P><P></P><P>Depending on the condition, you can use something like</P><P></P><PRE class="language-none line-numbers"><CODE>CONTAINS('PATH:\"/app:companyhome//*\"')<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Mon, 11 Mar 2019 17:13:41 GMT https://connect.hyland.com/t5/alfresco-forum/cmis-query-with-in-tree/m-p/46709#M18558 angelborroy 2019-03-11T17:13:41Z Re: CMIS Query with IN_TREE https://connect.hyland.com/t5/alfresco-forum/cmis-query-with-in-tree/m-p/46710#M18559 <HTML><HEAD></HEAD><BODY><P>The question&nbsp;then would be, "why" can't you combine more than one IN_TREE clause? Is this some hard-coded implementation of Alfresco that limits this? Because conceptually, it feels like one should be able to do something like this, since content items in CMIS are allowed to be multi-filed, and by combinding two IN_TREE&nbsp;clauses you could filter results to find only those that actually are multi-filed.</P></BODY></HTML> Mon, 11 Mar 2019 21:24:24 GMT https://connect.hyland.com/t5/alfresco-forum/cmis-query-with-in-tree/m-p/46710#M18559 afaust 2019-03-11T21:24:24Z Re: CMIS Query with IN_TREE https://connect.hyland.com/t5/alfresco-forum/cmis-query-with-in-tree/m-p/46711#M18560 <HTML><HEAD></HEAD><BODY><P>I have a GUI in which the user selects a list of sites for downloading documents. I can not get all the documents from the selected sites in one request? For each site will have to form a separate request?</P></BODY></HTML> Wed, 13 Mar 2019 05:27:49 GMT https://connect.hyland.com/t5/alfresco-forum/cmis-query-with-in-tree/m-p/46711#M18560 viktoriyamoskov 2019-03-13T05:27:49Z