topic Boolean searches with NOT in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/boolean-searches-with-not/m-p/119488#M84233 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I've read through the </SPAN><A href="http://wiki.alfresco.com/wiki/Search#The_query_parser" rel="nofollow noopener noreferrer">Search documentation</A><SPAN> and see that "NOT" is not supported in some cases:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>Note that queries with a single "NOT" entry or single TERM query precided with "-" are not supported.<SPAN class="line-numbers-rows"><SPAN>โ€</SPAN></SPAN></CODE></PRE><BR /><SPAN>Unfortunately, this exception seems to apply also to </SPAN><STRONG>subqueries</STRONG><SPAN>.</SPAN><BR /><BR /><SPAN>Here are a few examples illustrating this; I used category searches so you can perform the queries in your Alfresco installation by tagging a few nodes with some of the Regions tags "Switzerland", "France", or "Liechtenstein".</SPAN><BR /><BR /><SPAN>"Switzerland AND France" (works):</SPAN><BR /><PRE class="language-none line-numbers"><CODE> PATH:"/cm:generalclassifiable//cm:Switzerland//member" AND PATH:"/cm:generalclassifiable//cm:France//member"<SPAN class="line-numbers-rows"><SPAN>โ€</SPAN></SPAN></CODE></PRE><BR /><SPAN>"Switzerland AND NOT France" (works):</SPAN><BR /><PRE class="language-none line-numbers"><CODE> PATH:"/cm:generalclassifiable//cm:Switzerland//member" AND NOT PATH:"/cm:generalclassifiable//cm:France//member"<SPAN class="line-numbers-rows"><SPAN>โ€</SPAN></SPAN></CODE></PRE><BR /><SPAN>"Switzerland AND (Liechtenstein OR NOT France) (</SPAN><STRONG>does not work</STRONG><SPAN><span class="lia-unicode-emoji" title=":disappointed_face:">๐Ÿ˜ž</span></SPAN><BR /><PRE class="language-none line-numbers"><CODE> PATH:"/cm:generalclassifiable//cm:Switzerland//member" AND ( PATH:"/cm:generalclassifiable//cm:Liechtenstein//member" OR NOT PATH:"/cm:generalclassifiable//cm:France//member")<BR /><SPAN class="line-numbers-rows"><SPAN>โ€</SPAN><SPAN>โ€</SPAN></SPAN></CODE></PRE><BR /><SPAN>It seems that OR makes the left and right operands individual clauses so that the exception applies. Is this so?</SPAN><BR /><BR /><SPAN>Funnily, if I put the last query from above into </SPAN><A href="http://en.wikipedia.org/wiki/Disjunctive_normal_form" rel="nofollow noopener noreferrer">Disjunctive Normal Form</A><SPAN> and oops, the thing works:</SPAN><BR /><BR /><SPAN>"Switzerland AND (Liechtenstein OR NOT France) (</SPAN><STRONG>works</STRONG><SPAN><span class="lia-unicode-emoji" title=":disappointed_face:">๐Ÿ˜ž</span></SPAN><BR /><PRE class="language-none line-numbers"><CODE> ( PATH:"/cm:generalclassifiable//cm:Switzerland//member" AND PATH:"/cm:generalclassifiable//cm:Liechtenstein//member") OR ( PATH:"/cm:generalclassifiable//cm:Switzerland//member" AND NOT PATH:"/cm:generalclassifiable//cm:France//member")<BR /><SPAN class="line-numbers-rows"><SPAN>โ€</SPAN><SPAN>โ€</SPAN></SPAN></CODE></PRE><BR /><SPAN>So:</SPAN><BR /><BR /><SPAN>1. Is what I observe a bug or is it a consequence of the aforementioned exception rule?</SPAN><BR /><BR /><SPAN>2. How can I make Boolean queries work? Do I have to convert to DNF?</SPAN><BR /><BR /><SPAN>3. Is this an Alfresco or Lucene issue?</SPAN><BR /><BR /><SPAN>4. Will Alfresco (Lucene?) support Boolean queries in the future?</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Kaspar</SPAN></BODY></HTML> Thu, 13 Dec 2007 15:01:51 GMT hbf 2007-12-13T15:01:51Z Boolean searches with NOT https://connect.hyland.com/t5/alfresco-archive/boolean-searches-with-not/m-p/119488#M84233 Hi,I've read through the Search documentation and see that "NOT" is not supported in some cases:Note that queries with a single "NOT" entry or single TERM query precided with "-" are not supported.โ€Unfortunately, this exception seems to apply also to subqueries.Here are a few examples illustrating t Thu, 13 Dec 2007 15:01:51 GMT https://connect.hyland.com/t5/alfresco-archive/boolean-searches-with-not/m-p/119488#M84233 hbf 2007-12-13T15:01:51Z Re: Boolean searches with NOT https://connect.hyland.com/t5/alfresco-archive/boolean-searches-with-not/m-p/119489#M84234 <HTML><HEAD></HEAD><BODY><P>I have the same issue with Alfresco 5.2 Enterprise Edition.</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P><SPAN>1. Is what I observe a bug or is it a consequence of the aforementioned exception rule?</SPAN><BR /><BR /><SPAN>2. How can I make Boolean queries work? Do I have to convert to DNF?</SPAN><BR /><BR /><SPAN>3. Is this an Alfresco or Lucene issue?</SPAN><BR /><BR /><SPAN>4. Will Alfresco (Lucene?) support Boolean queries in the future?</SPAN></P></BLOCKQUOTE><P>Can someone answer the questions?</P></BODY></HTML> Wed, 28 Aug 2019 05:38:58 GMT https://connect.hyland.com/t5/alfresco-archive/boolean-searches-with-not/m-p/119489#M84234 lukask 2019-08-28T05:38:58Z