[Resolved] Help with DUPLICATE function

Gabbitas

Hi All,

I'm really struggling with how to duplicate reference lists inside a BO. I have tried lots of methods over the last week to no avail. If anyone has any thoughts on how to solve my problem I would be very grateful.

So here is my scenario:

I have a business object called Family. It has a reference list that contains Children. The Children BO contains a further reference list of Grandchildren. The family BO can have many Children and each Children BO can have many Grandchildren.

Now what I want to do is duplicate the Family BO along with its Children and Grandchildren.

I can duplicate the Family BO and the Children BO without any trouble by using the following process:

DUPLICATE Family
DUPLICATE Family.Children TO ThatFamily.Children

The problem comes when I go a step further and try to duplicate the Grandchildren. If I use the following additional rule in my process and I have multiple Grandchildren in each Children it fails:

DUPLICATE Family.Children.Grandchildren TO ThatFamily.Children.Grandchildren

I know that the above isn't the correct approach to duplicating the Grandchildren and I've tried very hard to creatively finding a workaround. I think the answer lies IN BATCHES OF 1 somehow but can't figure it out. Any ideas?

Many thanks in advance

BTW I'm still using V6 if that makes a difference to any possible solution.

pureist

It's a bit of a segue, but it seems to me like all 3 database tables/objects could be combined into the one (with applicable attributes shown on a separate forms: 'Family', 'Children', etc.), or at least the children and grandchildren objects could be the one object (because grandchildren are just children of children or children), by using a reference attribute in the child object which references the child object.
That way , also, it is simple to go to great grandchildren and great great grandchildren or nth level grandchild, if you ever wanted

pureist

children of children OF children

pureist

Arggggh!
children of children from the perspective of the 'Family' object in your scenario

Gabbitas

Hi Pureist,

Thanks for your reply but it wouldn't be possible to combine all my BOs into one. The Family, Children and Grandchildren BOs are a simple way to explain my real life situation. My real life BOs are very complex with many attributes and many rules. Besides even if I did combine all 3 they would still need to be related to each other - unless I'm missing something I don't see how the relationship would be any easier to duplicate.

Thanks

pureist

Gabbitas wrote
Hi Pureist,
Thanks for your reply but it wouldn't be possible to combine all my BOs into one. The Family, Children and Grandchildren BOs are a simple way to explain my real life situation. My real life BOs are very complex with many attributes and many rules. Besides even if I did combine all 3 they would still need to be related to each other - unless I'm missing something I don't see how the relationship would be any easier to duplicate.
Thanks

I just found it's easier to get your head around it you have the one database table/object with enough fields/attributes to cover all possible permutations, and to have separate forms where required which only contain fields applicable to the purpose of the form. The 'child' object itself would have a reference attribute 'children' which is of type 'child' with multiple being enabled.

tford

I think the answer lies IN BATCHES OF 1 somehow but can't figure it out. Any ideas?

Seems like after Children are created you should be able to use FIND ... IN BATCHES OF to sequentially go through each of the Children and use the same type of process that you used to duplicate Children.

BenHayat

I had put together an article that could be helpful.
https://www.awareim.com/forum/d/8022>

Gabbitas

Ben / Tom,

I know this thread is old now, I've been busy on other projects, but I just wanted to thank you for your pointers on this one. I downloaded the sample BSV that you created and from that I was able to solve my problem. IN BATCHES OF 1 along with DUPLICATE done the trick. It was my understanding of (or lack of) the context passed from process to process that let me down.

Thank You

BenHayat

Gabbitas wrote
Ben / Tom,

I know this thread is old now, I've been busy on other projects, but I just wanted to thank you for your pointers on this one. I downloaded the sample BSV that you created and from that I was able to solve my problem. IN BATCHES OF 1 along with DUPLICATE done the trick. It was my understanding of (or lack of) the context passed from process to process that let me down.

Thank You

No problem.

Please change the title to:
[Resolved] Help with DUPLICATE function