Delete Rule context processing question

nlarson

Hi, just wondering about how context is formed when a record is deleted is handled in terms of using a "this or that" qualifier.

What I am looking to do is recalculate a the sum of remaining child records to the parent record when a single child is deleted. So I am wondering if the deleted record is held in context until all rules are processed?

tford

I'm curious why you need to manage this calculation?

If you have a rule:
Parent.Total=SUM Child.Amount WHERE (Child IN P.Children)
the Parent.Total will update automatically when a Child record is deleted.

nlarson

Hi Tom, it is entirely possible I am doing this bass-ackwards, but the way I have some rules set up is that a change at the child will populate up to the parent.

so in one example, my rule looks like this:

Metrics.GoalsReference.Current=SUM Metrics.ActualContributiveScore WHERE (Metrics.GoalsReference=ThisMetrics.GoalsReference)
Metrics.GoalsReference.Expected=SUM Metrics.ExpectedContributiveScore WHERE (Metrics.GoalsReference=ThisMetrics.GoalsReference)
Metrics.GoalsReference.TotalMetricWeight=SUM Metrics.Weight WHERE (Metrics.GoalsReference=ThisMetrics.GoalsReference)

Seems to be working A-Ok except it does not recalculate if a record is delete. So I was just going to modify delete rule.

At some point I need to hire an expert to review all my work (hint hint :lol: )...