complicated calculation

Hubertus

I have Delivery --> Order --> OrderDetails <-- Product (--> means 1:N)
I need to summarize the amount from OrderDetails by Product for a whole Delivery. With these amounts (1 for every product) I'd need to calculate ceiling(sum/1000). And finally I need to sum up the results from the ceiling function calls and place it into Delivery

Can this be done with AwareIM ? 😮

Thanks a lot for any hints,
Hubertus

aware_support2

Hubertus,

You need to add a non-persistent object DeliveryProduct and a rule to object Delivery with the following actions:

FIND Product WHERE EXISTS OrderDetails WHERE (OrderDetails.Order.Devlivery = Delivery AND OrderDetails.Product = Product)

FOR EACH Product CREATE DeliveryProduct WITH DeliveryProduct.Delivery = Delivery, DeliveryProduct.CeilingTotal = CEILING(SUM OrderDetails.Total WHERE (OrderDetails.Order.Devlivery = Delivery AND OrderDetails.Product = Product) / 1000)

Delivery.CeilingTotal = SUM DeliveryProduct.CeilingTotal WHERE (DeliveryProduct.Delivery = Delivery)

Hubertus

wow, thanks !
I was expecting a hint, not a solution 8-)