Re: [rules-users] Disting and group by

Thanks Wolfgang and Edson for your help i was able to make it work below is my rule declare ReportForDate custNo : String chargeDate : Date end rule "insert report dates" salience 10 dialect "mvel" when $lineItems : Customer (person != null, $custNo : person.ID, $ChargeDate : lineItemDate) not( ReportForDate( custNo == $custNo, chargeDate == $ChargeDate ) ) then with( $r = new ReportForDate() ) { custNo = $custNo, chargeDate = $ChargeDate } insert( $r ); end rule "customers that purchased more than 100 on a given date" when $CustDateInfo : ReportForDate($custNo : custNo, $ChargeDate : chargeDate) $dayTotal : Number(doubleValue > 100) from accumulate( Customer ( person.ID == $custNo, lineItemDate == $ChargeDate , $amt : amount ) , sum( $amt ) ) then System.out.println("********* customer " + $custNo +" billed over 100 per day"); end -- View this message in context: http://drools-java-rules-engine.46999.n3.nabble.com/Distinct-and-group-by... Sent from the Drools - User mailing list archive at Nabble.com.