topic multiple options in one query in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/multiple-options-in-one-query/m-p/23640#M11454 <HTML><HEAD></HEAD><BODY><SPAN>Hello there. </SPAN><BR /><BR /><SPAN>I have a doubt of doing multiple conditions in a query. I have this: </SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />"PATH:\"app:company_home/cm:services//.\""); <BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>So i get all the nodes of the specific path. </SPAN><BR /><BR /><SPAN>But from the results, i would like to obtain just the ones which in its name has the name "BIRD", so i would like to do so in the query, instead of having to do a if-else sentence. That would be</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />AND TEXT:\"BIRD \"<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>And the hole search…</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />sp.setQuery("PATH:\"app:company_home/cm:services//.\" AND TEXT:\"BIRD\"");<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>But the resultSet is empty, when should give 3 results. </SPAN><BR /><BR /><SPAN>What is wrong? </SPAN><BR /><BR /><SPAN>Thanks</SPAN><BR /><SPAN>Bird</SPAN></BODY></HTML> Thu, 03 Aug 2006 07:51:17 GMT unknown-user 2006-08-03T07:51:17Z multiple options in one query https://connect.hyland.com/t5/alfresco-archive/multiple-options-in-one-query/m-p/23640#M11454 Hello there. I have a doubt of doing multiple conditions in a query. I have this: "PATH:\"app:company_home/cm:services//.\""); ‍‍‍So i get all the nodes of the specific path. But from the results, i would like to obtain just the ones which in its name has the name "BIRD", so i would like to do so in Thu, 03 Aug 2006 07:51:17 GMT https://connect.hyland.com/t5/alfresco-archive/multiple-options-in-one-query/m-p/23640#M11454 unknown-user 2006-08-03T07:51:17Z Re: multiple options in one query https://connect.hyland.com/t5/alfresco-archive/multiple-options-in-one-query/m-p/23641#M11455 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><BR /><SPAN>This should work.</SPAN><BR /><BR /><SPAN>What results do you get for TEXT:\"BIRD\" ?</SPAN><BR /><BR /><SPAN>I would try using the + syntax instead as there are issues with AND in lucene 1.4.3.</SPAN><BR /><BR /><SPAN>"+PATH:\"app:company_home/cm:services//.\" +TEXT:\"BIRD\""</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><BR /><SPAN>Andy</SPAN></BODY></HTML> Thu, 03 Aug 2006 14:28:42 GMT https://connect.hyland.com/t5/alfresco-archive/multiple-options-in-one-query/m-p/23641#M11455 andy 2006-08-03T14:28:42Z