topic Doubt about Lucene search terms and grouping of terms in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/doubt-about-lucene-search-terms-and-grouping-of-terms/m-p/198873#M152003 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I'm trying to make a Lucene query and I'm using documentation provided by Lucene and Alfresco's wiki, but when I test my query in the node browser I always get all the nodes of the folder where I'm searching for.</SPAN><BR /><BR /><SPAN>Here is the query I'm using:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />+PATH:"/app:company_home/cm:customPath/cm:customChild/cm:folder/*"<BR />@cm\:name:"queryTerm" @cm\:title:"queryTerm" @cm\:description:"queryTerm"<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>(I've separated the query to make it more readable)</SPAN><BR /><BR /><SPAN>I want to search for the nodes contained in the given folder and matching any of the given fields. If no field matchs with 'queryTerm' the query must return an empty array.</SPAN><BR /><BR /><SPAN>I think the equivalent SQL code of the Lucene query that I want to make should look like this:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />SELECT * FROM table WHERE path="path/to/folder" AND (field1 LIKE queryTerm OR field2 LIKE queryTerm OR field3 LIKE queryTerm …)<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Any help?</SPAN><BR /><BR /><SPAN>Thanks!</SPAN></BODY></HTML> Tue, 11 Nov 2008 12:29:49 GMT damiar 2008-11-11T12:29:49Z Doubt about Lucene search terms and grouping of terms https://connect.hyland.com/t5/alfresco-archive/doubt-about-lucene-search-terms-and-grouping-of-terms/m-p/198873#M152003 Hi,I'm trying to make a Lucene query and I'm using documentation provided by Lucene and Alfresco's wiki, but when I test my query in the node browser I always get all the nodes of the folder where I'm searching for.Here is the query I'm using:+PATH:"/app:company_home/cm:customPath/cm:customChild/cm: Tue, 11 Nov 2008 12:29:49 GMT https://connect.hyland.com/t5/alfresco-archive/doubt-about-lucene-search-terms-and-grouping-of-terms/m-p/198873#M152003 damiar 2008-11-11T12:29:49Z Re: Doubt about Lucene search terms and grouping of terms https://connect.hyland.com/t5/alfresco-archive/doubt-about-lucene-search-terms-and-grouping-of-terms/m-p/198874#M152004 <HTML><HEAD></HEAD><BODY><SPAN>Try</SPAN><BR /><PRE class="language-none line-numbers"><CODE>+PATH:"/app:company_home/cm:customPath/cm:customChild/cm:folder/*"<BR />+@cm\:name:"queryTerm" +@cm\:title:"queryTerm" +@cm\:description:"queryTerm"<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Note the + signs.</SPAN><BR /><BR /><SPAN>Mike</SPAN></BODY></HTML> Tue, 11 Nov 2008 14:36:51 GMT https://connect.hyland.com/t5/alfresco-archive/doubt-about-lucene-search-terms-and-grouping-of-terms/m-p/198874#M152004 mikeh 2008-11-11T14:36:51Z Re: Doubt about Lucene search terms and grouping of terms https://connect.hyland.com/t5/alfresco-archive/doubt-about-lucene-search-terms-and-grouping-of-terms/m-p/198875#M152005 <HTML><HEAD></HEAD><BODY><SPAN>I used this query and it has worked fine <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://connect.hyland.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />+PATH:"/app:company_home/cm:customNode/cm:customChild/cm:folder/*" <BR />AND <BR />(@cm\:name:"searchTerm" OR @cm\:title:"searchTerm")<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Thanks for your help!</SPAN></BODY></HTML> Tue, 11 Nov 2008 16:37:44 GMT https://connect.hyland.com/t5/alfresco-archive/doubt-about-lucene-search-terms-and-grouping-of-terms/m-p/198875#M152005 damiar 2008-11-11T16:37:44Z