Update A from B transactions

vinsnash

If there is an Object_B that is generated transactions from a process is there a way to use Object_B to update particular instances of Object_A. "FOR EACH" works with "CREATE" but not "FIND".

For example:

Using Object_B as a "driving file" find all the Object_B instances that match a condition and then for each found Object_B update an Object_A instance with an attribute that matches the found Object_B attribute.

Vins Nash

tford

Either use IN BATCHES OF or have 2 different processes.

vinsnash

I've been reading the user guide but I don't fully understand. If I use an object "Pending" as input to a process will the process act on every instance of "Pending"? In the examples they are always using a literal as the condition but I need to use an attribute of the input object as a condition.

Example:

FIND NSCPers WHERE Pending.SSN = NSCPers.SSN
NSCPers.MemberStatus = Pending.MemberStatus
NSCPers.DatePaid = Pending.Date
NSCPers.AmountPaid = Pending.Amount

I need to have every instance of "NSCPers" with a matching SSN in "Pending" updated with values from attributes of "Pending". All instances of "Pending" will be deleted after they are processed.

With "Pending" as process input will these rules, below, act on every instance of "Pending" that meets the condition? Batch size is irrelevant, I think. There probably wouldn't be more than 50 instances of "Pending" on any day.

FIND Pending WHERE Pending.Date = CURRENT_DATE
FIND NSCPers WHERE NSCPers.SSN = Pending.SSN
NSCPers.MemberStatus = Pending.MemberStatus
NSCPers.DatePaid = Pending.Date
NSCPers.AmountPaid = Pending.Amount

Vins Nash

vinsnash

I'm trying to follow the user guide on this but I just can't make sense of it. If I specify an input to a process and use a "FIND" as in the example the result is a display of all the input instances demanding I select an item to process. Then it only acts on the instance from the query result displayed that I select. All the examples use a literal as a condition. I need to use a value in an attribute. If I use "FIND ALL" "IF" causes a syntax error. If I don't specify an input to the process "ALL" works but only one instance of "Object B" is processed. I need to match transactions in an "Object B" that have the same value in an attribute as "Object A" and then update "Object A" with values from "Object B". Is this somehow possible? None of the examples makes sense to me.

If I was programming this I would read "Object B" use a "key" attribute in "Object B" to read the "Object A" instance and on a successful "read" update "Object A" with values from "Object B". I would loop this routine until there were no more "Object B". This has to be a fairly common task but unfortunately from the examples given in the user guide I can't figure it out.

I really need help on this because it is an accounting/audit show stopper If I can't do it.

Vins Nash

aware_support

Move rules after the first FIND into a separate process that uses Pending as input. Call it ProcessPending, for example. It will process one instance of Pending:

FIND NSCPers WHERE NSCPers.SSN = Pending.SSN
NSCPers.MemberStatus = Pending.MemberStatus
NSCPers.DatePaid = Pending.Date
NSCPers.AmountPaid = Pending.Amount

Your main process will then look like this:

FIND Pending WHERE Pending.Date = CURRENT_DATE
ProcessPending

technopak

Hi,

I'm assuming that there can only be one Pending for a particular NSCPers. If so, here is an alternative suggestion -

You could create a rule in the Pending object which automatically updates the related NSCPers object when Pending IS NEW.

Something like this should work -

IF Pending IS NEW AND EXISTS NSCPers WHERE NSCPers.SSN = Pending.SSN THEN
FIND NSCPers WHERE NSCPers.SSN = Pending.SSN
NSCPers.MemberStatus = Pending.MemberStatus
NSCPers.DatePaid = Pending.Date
NSCPers.AmountPaid = Pending.Amount

Using this method, you don't need any to worry about any processes - you'd just have to tidy up by dumping the Pendings periodically.

Peter