topic Re: How to search within a particular folder in the repository in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/how-to-search-within-a-particular-folder-in-the-repository/m-p/302345#M255475 <HTML><HEAD></HEAD><BODY><BR /><SPAN>Use IN_FOLDER() or IN_TREE() function in your cmis query.</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />SELECT cmis:name FROM cmis:document WHERE IN_FOLDER('folder id') //IN_FOLDER() matches the immediate children of a folder<BR />SELECT cmis:name FROM cmis:folder F WHERE IN_TREE(F, 'folder id') //IN_TREE matches any object beneath the folder.<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Fri, 19 Sep 2014 13:02:29 GMT kaynezhang 2014-09-19T13:02:29Z How to search within a particular folder in the repository https://connect.hyland.com/t5/alfresco-archive/how-to-search-within-a-particular-folder-in-the-repository/m-p/302344#M255474 Hi,I have multiple folder within the repository. I want to search for documents within 1 particular folder using DotCMIS. How do i do that ?Regards,Rita Fri, 19 Sep 2014 09:46:00 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-search-within-a-particular-folder-in-the-repository/m-p/302344#M255474 rita_aiyar 2014-09-19T09:46:00Z Re: How to search within a particular folder in the repository https://connect.hyland.com/t5/alfresco-archive/how-to-search-within-a-particular-folder-in-the-repository/m-p/302345#M255475 <HTML><HEAD></HEAD><BODY><BR /><SPAN>Use IN_FOLDER() or IN_TREE() function in your cmis query.</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />SELECT cmis:name FROM cmis:document WHERE IN_FOLDER('folder id') //IN_FOLDER() matches the immediate children of a folder<BR />SELECT cmis:name FROM cmis:folder F WHERE IN_TREE(F, 'folder id') //IN_TREE matches any object beneath the folder.<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Fri, 19 Sep 2014 13:02:29 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-search-within-a-particular-folder-in-the-repository/m-p/302345#M255475 kaynezhang 2014-09-19T13:02:29Z