FOR EACH within FOR EACH Loop???

BenHayat

Hi;

I don't have any more hair to pull on this case.
Let's say, I have an object called Vendor and anoth Object called Book. Book is a child of Vendor

I need to read the Vendor table and create a new Vender from the one it was read and just modify a few things.
This is done via a Find action first using IN BATCHES OF 1 , then using CREATE Vendor FOR EACH ThisVendor WITH
xxxxxxxx

This is fine and works. However my challenge is that, for every Vendor that it's created, in that moment that I have the NEW Vendor created, I need to create a series of Books as well, and assign Book's parent to the new Vendor.
I can't get Aware to do a FOR EACH within another FOR EACH.

In any other language, you have a FOR EACH loop that you can have another FOR EACH loop inside.
It's been 2 days, and I get very odd results or infinite loops.
Any help or guide is appreciated.

tford

IN BATCHES OF 1 within IN BATCHES OF 1 should definitely be possible.

Since you are adding new instances to Vendor BO as you are performing a FIND on that BO, I wonder if that could be part of your infinite loop? Are you

I also don't think FOR EACH applies in your scenario. The IN BATCHES OF 1 already creates a situation that you are dealing with each instance on it's own.

If you could post a sample BSV of the exact structure and syntax you have attempted, I might be able to help ID the issue.

BenHayat

tford wrote
IN BATCHES OF 1 within IN BATCHES OF 1 should definitely be possible.
Since you are adding new instances to Vendor BO as you are performing a FIND on that BO, I wonder if that could be part of your infinite loop? Are you
I also don't think FOR EACH applies in your scenario. The IN BATCHES OF 1 already creates a situation that you are dealing with each instance on it's own.
If you could post a sample BSV of the exact structure and syntax you have attempted, I might be able to help ID the issue.

Hi Tom;

IN BATCHES OF 1 within IN BATCHES OF 1

Could you elaborate on this? Perhaps with an statement showing?

If you could explain to me how I can perform a loop within a loop in Aware, this will be a huge help.
Thank you in advance!

tford

Rather than talking theory, it's always easier for me with examples.

If you will provide this, I can take a look at it and likely tweak it to work:

If you could post a sample BSV of the exact structure and syntax you have attempted, I might be able to help ID the issue.

BenHayat

tford wrote
Rather than talking theory, it's always easier for me with examples.

If you will provide this, I can take a look at it and likely tweak it to work:

If you could post a sample BSV of the exact structure and syntax you have attempted, I might be able to help ID the issue.

Sure, I'll put together a BSV and notes, what I'm trying to accomplish. Another challenge I have, is that, how I need to break these into multiple Processes. If I do within one process (multiple rules), I get to see all the objects in context to use, but the looping doesn't work.
If first loop calls another process, the the looping works, but the other processes don't the context data (even though I'm passing the objects as input).
So, I'm in a catch 20/20.

Thank you in advance!

tford

Hopefully when we are done, Ben, we will end up with an example BSV that can guide folks trying to looping / iterative scenarios in the future.

BenHayat

tford wrote
Hopefully when we are done, Ben, we will end up with an example BSV that can guide folks trying to looping / iterative scenarios in the future.

Once you see the notes, what needs to be accomplished, I don't think Aware can handle it. Mainly because:
a) You create/duplicate a new Parent object first. Both must reside in context (I have been able to do so)
b) Then before moving to the next Parent creation/duplication, the existing parent's children must be duplicated under the new parent. This is where the challenge comes, in order to provide the new child, it's new father that was recently created.

I tried, "This", "That", "Added", but none gives me a reference in the context for the newly created father. So, all the new children created, become orphan.
This was just a heads up before putting the notes together and create a sample BSV.
The "This", "That", don't work correctly especially when you try to pass from one process to another process by "USING" statement. Nothing gets passed.

tford

Gotcha. Perhaps storing the instances in a SystemSetting or LoggedInSystemUser attribute would allow then to be kept straight?

BenHayat

tford wrote
Gotcha. Perhaps storing the instances in a SystemSetting or LoggedInSystemUser attribute would allow then to be kept straight?

Yes, I have also gone the route of storing the instance in SystemUser (it has to be systemUser not SystemSettings due to multi user attempting this) so I can use it in the process. It solved my first level of creating the parent. But my challenge is (after 3 days) trying to do loop in a loop.
Aware is very inflexible in this area.

Tom, I'd like to send the BSV directly to your email, so we can follow up via email and then we can post the net result here. I'm working creating a new BSV to simulate the what I need to do.

Please give me your email address.
Thanks in advance!

customaware

Ben,
I am not sure if you have solved your problem and possibly with Tom's help and suggestions you have.

However, here is an article I have gone back to many times just to reinforce it in my head....

This interesting and important points in there is that when you have a FIND after a FIND, the second FIND destroys the context of the first FIND.

http://www.hiden.org/awareim/the-execution-context-of-awareim/

So, reading his article.... if you have IN BATCHES OF 1 in the top process then I am pretty sure you can achieve (I haven't tried and example yet but intend to)
the Double FOR loops you were asking about. In any event, I have found it an excellent article and would love to compile a collection of similar articles that
clearly explain Aware IM context.

I remember many years ago Keith Canniff from the Magic community made the point..... "In Magic.... if it takes more than 20 mins to figure out, then you are probably doing it wrong."
I think the same applies for Aware. The Process and Context model is extraordinarily powerful but can seem daunting and complex if approached in the wrong way.

I still always get messed up know when and what actions could/should be bundled in a single Rule of a Process or when they should be split into separate Rules...as opposed to separate Processes / Sub Processes. I eventually always arrive at a solution but lack the clarity in my head to know from the get go exactly how it is to be done. Most often it is by trial and error to arrive at a result. But I am a firm believer in the adage that practice makes perfect.

BenHayat

Thanks Mark;

Tom is a gentleman & scholar... He has helped me getting through this challenge, by producing the process structure that I need to use in my application. Once I get it to work in my app, I will then put a post in Tips & Tricks with his BSV to show how the Loop inside of a Loop is done.

I still always get messed up know when and what actions could/should be bundled in a single Rule of a Process or when they should be split into separate Rules...as opposed to separate Processes / Sub Processes. I eventually always arrive at a solution but lack the clarity in my head to know from the get go exactly how it is to be done. Most often it is by trial and error to arrive at a result. But I am a firm believer in the adage that practice makes perfect.

Same with me. I think there is a lot of materials that should be included in the docs about Context that is missing.
there is no clear map or knowledge, especially when you go from one process to another, things gets lost in context. We had to store objects in Customer object which is an ugly way of doing things.

Magic was much more straight forward and we much better control than Aware.

I wish Support would provide a better guideline regarding this black box.

customaware

Not sure if this is what you are after Ben but it might help.

Two BOs. One called Outside and one called InSide.

Outer loop process FINDs particular OurSIde BO subject to WHERE and then calls and Inside Process which FINDs Inside BO subject to
particular conditions of each OutSide BO and then calls another subprocess to set a value in the found Inside BO.

It will auto create the data.

Change to the Inside tab and you will see the Inside records.
Click the Run Loop Process and you will see the Values in particular InSide records updated according to the process FINDS
Click Reset Inside Loop Values to set them back to zero.

As I say..... not sure it this helps but it does demonstrate a FOR Loop inside another FOR loop.

Let me know if it should be something different.

ForLoops.zip

35.82kB

BenHayat

The final resolution is moved to Tips & Tricks section with a BSV.

https://www.awareim.com/forum/d/8022>

BenHayat

eagles9999 wrote
Not sure if this is what you are after Ben but it might help.

Two BOs. One called Outside and one called InSide.

Outer loop process FINDs particular OurSIde BO subject to WHERE and then calls and Inside Process which FINDs Inside BO subject to
particular conditions of each OutSide BO and then calls another subprocess to set a value in the found Inside BO.

It will auto create the data.

Change to the Inside tab and you will see the Inside records.
Click the Run Loop Process and you will see the Values in particular InSide records updated according to the process FINDS
Click Reset Inside Loop Values to set them back to zero.

As I say..... not sure it this helps but it does demonstrate a FOR Loop inside another FOR loop.

Let me know if it should be something different.

[attachment=0]ForLoops.zip[/attachment]

Thanks Mark, I'll look at the code.

ACDC

When it comes to this type of scenario where there is a Loop and "chaining" of processes, I have found that its much easier to start off with a Process and then rely on a rule on the object to finish the process. This way you can always be assured of context and also get into some really complex rules firing.

So, CREATE the Object and Then on the Object have a rule that goes IF Object IS NEW Then .....

tford

When it comes to this type of scenario where there is a Loop and "chaining" of processes, I have found that its much easier to start off with a Process and then rely on a rule on the object to finish the process. This way you can always be assured of context and also get into some really complex rules firing.

So, CREATE the Object and Then on the Object have a rule that goes IF Object IS NEW Then .....

Excellent observation!