Hi,

 

I have tried to implement 2 levels (nested) of sorting / distribution (Date and Proportionate) in Drools and failed :-(. I could not accomplish when the second level was ‘proportionate’. Let me clear the terms before I give the example.

 

2 level --> The criteria chosen for the first level is same then only apply the second level criteria. In SQL terms it would be “order by date, avg price”. The first level was Date.

Proportionate --> Proportionate means distribute the items / amount as proportion to what it contains.

 

The rule that is mentioned below did not work. There was no issue in implementing sequence number as second priority.

 

What happens is that the “$totalTrancheAmount” does not include the facts (Tranche objects) that were already matched or being matched. Basically the sum is always of the facts that are ‘yet’ to be matched.

 

Also what is needed is a fact understanding whether Tranche got selected as a “proportionate” one or only based on date. For this we can use if ($totalTrancheAmount > 0) condition on “then” side I suppose.

 

Is there any way of getting hold of all facts which taking sum of childTrancheValue?

 

rule "LIFO And Proportionate"

dialect "java"

salience 101

      when

            $product : Product($productSeq : productSeq, vestedAmt > 0)

            $tranche : Tranche(productSeq == $productSeq, $maintrancheSeq : trancheSeq, $trancheValue : trancheValue > trancheVestedAmt, $trancheCreationDate : trancheCreationDt)

            not Tranche(claimProductSeq == $claimProductSeq, trancheSeq != $maintrancheSeq, trancheValue > trancheVestedAmt, trancheCreationDt > $trancheCreationDate )

            and

            (

                  $totalTrancheAmount : Double () from accumulate ( Tranche($childtrancheValue : trancheValue, trancheCreationDt == $trancheCreationDate, trancheValue > trancheVestedAmt), sum( $childtrancheValue ))

                  or

                  eval(true)

            )

      then

            // Vesting should happen based on proportionate if the dates were matched otherwise based on which amount is greater.

            // Proportionate = $trancheValue / $ totalTrancheAmount

            vestTranche($claimProductDetail, $trancheDetail);

            System.out.println(“$totalTrancheAmount : “ + $ totalTrancheAmount);

            update ($trancheDetail);

            update ($claimProductDetail);

end

Thanks.

Regards,

- Nimesh