topic Lucene query in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/lucene-query/m-p/20654#M9098 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #2a2e2e;">Hallo, I hope ask my question in the right forum. Im not a data analyst. So I have only a small knowledge. I have a data analysis tool for that I need lucency query language. Simple query I can do. But I don't know how to define a query with conditions.</SPAN><BR style="color: #2a2e2e;" /><SPAN style="color: #2a2e2e;">My dataset looks like: Transactions from customers. Each transaction the customer can only buy 1 item. The datable looks like that:</SPAN><BR style="color: #2a2e2e;" /><SPAN style="color: #2a2e2e;">Customer Produkt Price Date</SPAN><BR style="color: #2a2e2e;" /><SPAN style="color: #2a2e2e;">1 A 10$ 01.01.2017</SPAN><BR style="color: #2a2e2e;" /><SPAN style="color: #2a2e2e;">1 B 12$ 01.02.2107</SPAN><BR style="color: #2a2e2e;" /><SPAN style="color: #2a2e2e;">2 C 8$ 03.04.2017 </SPAN><BR style="color: #2a2e2e;" /><SPAN style="color: #2a2e2e;">3 B 12$ 23.06.2017</SPAN><BR style="color: #2a2e2e;" /><SPAN style="color: #2a2e2e;">The query which im searching for has to show the result: all customers who have bought product A and produkt B in the last year. </SPAN><BR style="color: #2a2e2e;" /><SPAN style="color: #2a2e2e;">The problem is if I I ask produkt: A AND Produkt B than it shows me the sum (customer 1 and customer 3) and not only the customers who have bought both. The result I want to have is only customer 1. </SPAN><BR style="color: #2a2e2e;" /><SPAN style="color: #2a2e2e;">Can somebody help me?</SPAN><BR style="color: #2a2e2e;" /><SPAN style="color: #2a2e2e;">I would appreciate an answer very much! <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 style="color: #2a2e2e;" /><SPAN style="color: #2a2e2e;">Kindly regards </SPAN><BR style="color: #2a2e2e;" /><SPAN style="color: #2a2e2e;">Jenny</SPAN></P></BODY></HTML> Tue, 03 Oct 2017 11:49:20 GMT marypk 2017-10-03T11:49:20Z Lucene query https://connect.hyland.com/t5/alfresco-forum/lucene-query/m-p/20654#M9098 Hallo, I hope ask my question in the right forum. Im not a data analyst. So I have only a small knowledge. I have a data analysis tool for that I need lucency query language. Simple query I can do. But I don't know how to define a query with conditions.My dataset looks like: Transactions from custom Tue, 03 Oct 2017 11:49:20 GMT https://connect.hyland.com/t5/alfresco-forum/lucene-query/m-p/20654#M9098 marypk 2017-10-03T11:49:20Z Re: Lucene query https://connect.hyland.com/t5/alfresco-forum/lucene-query/m-p/20655#M9099 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>What version of Alfresco are you using?</P><P>What data analysis tool are you using and how are you using it with Alfresco?</P><P></P><P>Andy</P></BODY></HTML> Wed, 04 Oct 2017 09:13:59 GMT https://connect.hyland.com/t5/alfresco-forum/lucene-query/m-p/20655#M9099 andy1 2017-10-04T09:13:59Z