Using Loop to Get Order Total
Posted: September 2nd, 2021, 7:58 am
We read the multiple order records. Then use Loop to find the order total for every order.
Loop on F4201.
Loop Process
Query on F4211 to get order total
Use InserAndUpdateLoopNode To Add OrderTotal node back to loop node.
Run and Review output.
Try it yourself.
- Read Multiple Orders.png (184.41 KiB) Viewed 5243 times
- Read Multiple Orders.png (184.41 KiB) Viewed 5243 times
- Loop on F4201.png (76.31 KiB) Viewed 5243 times
- Loop on F4201.png (76.31 KiB) Viewed 5243 times
- Loop Process.png (51.77 KiB) Viewed 5243 times
- Loop Process.png (51.77 KiB) Viewed 5243 times
- Query F4211 to Get Order Total.png (165.38 KiB) Viewed 5243 times
- Query F4211 to Get Order Total.png (165.38 KiB) Viewed 5243 times
- InsertAndUpdateLoopNode.png (109.66 KiB) Viewed 5243 times
- InsertAndUpdateLoopNode.png (109.66 KiB) Viewed 5243 times
- Run And Review.png (73.07 KiB) Viewed 5243 times
- Run And Review.png (73.07 KiB) Viewed 5243 times