Hi all,
I have a set of 4 tables, OrdersCP, Consumable Products, Consumable Packages and Packages. The use case is as follows:
I have actions defined to do #4 in tables Orders, and PkgItems and it works fine if there is 1 PkgItem in an order but it doesnโt work when there are 2 or more PkgItems in an Order.
The action chain doesnโt seem to process the PkgItems in sequence and creates more lines in Consumable Products than needed.
Here are the actions and some details I have set up.
Action Add Package Items
Action Add to CP Order: loop
Action Add to CP Order: add item
Action Add to CP Order: incr copied
Action Add to CP Order: repeat
This seems like a bug but maybe there is a different way to set it up. I think the repeat action is the culprit but I am not sure.
@Steve @Aleksi @Phil - any suggestions?
Thanks.
Solved! Go to Solution.
Iโm still not quite understanding the data hierarchy, and exactly which data is used to create the records.
One way that Iโve converted an โexecuteโฆโ action, in order to make it run in serial, is as follows.
Child records in this case already each had a sequence number (1,2,3,4โฆ) for them to be run in. I then added a Y/N Type [Complete?] column to each.
The Parent record had an โexecuteโฆโ action, which ran the Childโs action, but only on the single record that matched
MINROW( โchildโ , โsequence numberโ , NOT( [Complete?] ) )
The Childโs action was a group of 3 actions.
User | Count |
---|---|
36 | |
31 | |
28 | |
23 | |
18 |