DUPLICATE

nlarson · Post by **nlarson** » Fri Oct 18, 2013 1:33 am

I have a process which I want to used to Duplicate a parent and any child references. In my BSV the children are uniquely owned by the parent. The process is below - When executing an error is thrown 'Value of ParentReference must be provided'

DUPLICATE ThisObjectives
DUPLICATE ThisObjectives.DeliverablesReference TO ThatObjectives.DeliverablesReference

I have tried some other variations to specify THATbo.attribute directly to no avail. So is this function only meant to work where the children are not owned by the parent? Or am I doing something wrong?

Rennur · Post by **Rennur** » Fri Oct 18, 2013 5:48 am

I have a PROCESS which duplicates my BO and multiple references for that object without a glitch.

Note: The multi reference attribute is a PEER many-one relationship. The child's matching attribute is blank (not linking back to parent)

My process,
GENERAL:
Process > Process Input > Select BO you want to duplicate (Objectives)
TEXTUAL RULES:
Rule 1 - DUPLICATE Objectives
Rule 2 - Duplicate ThisObjectives.DeliverablesReference TO ThatObjectives.DeliverablesReference

This works for me.

I guess the questions is has the DUPLICATE function got and issue with parent-child owner of relationship type?

hpl123 · Post by **hpl123** » Fri Oct 18, 2013 9:09 am

I use the DUPLICATE successfully in the following way:

CREATE Invoice
DUPLICATE ThisEstimate.Items TO Invoice.Items

I start this process from the Estimate BO.

nlarson · Post by **nlarson** » Fri Oct 18, 2013 2:29 pm

Yes Ren that is exactly the question, and as hlp123 pointed out it is working fine without ownership. So...

Anyone have this working in a owner of/ owned by relationship? Just wondering is DUPLICATE...To... is working as intended, has a bug, is missing a feature, I am making a pilot error?

RafaMD · Post by **RafaMD** » Sat Oct 19, 2013 4:38 am

It is possible. You have to duplicate the children and after asign the parent

Try this:

DUPLICATE ThisObjectives
FIND Deliverables WHERE Deliverables IN ThisObjetives.DeliverablesReference
DUPLICATE Deliverables EXCEPT Owner
ThatDeliverables.Owner=ThatObjetives

Rennur · Post by **Rennur** » Mon Oct 21, 2013 3:10 am

Hi Rafa,

Try this:

DUPLICATE ThisObjectives
FIND Deliverables WHERE Deliverables IN ThisObjetives.DeliverablesReference
DUPLICATE Deliverables EXCEPT Owner
ThatDeliverables.Owner=ThatObjetives

I'd like to to establish if there is a bug using the DUPLICATE function first before applying this workaround.

Anyone have this working in a owner of/ owned by relationship? Just wondering is DUPLICATE...To... is working as intended, has a bug, is missing a feature, I am making a pilot error?

I'll test this today.

Cheers

Rennur · Post by **Rennur** » Mon Oct 21, 2013 4:09 am

I have successfully duplicated Company BO with Contacts but did get an 'Value of ParentReference must be provided' error.

The ParentReference attribute in the Contacts object had the "Value must be provided' checkbox ticked.

Once I un-ticked the checkbox, the Company object and Contacts were duplicated.

Support, is the 'Value must be provided' checkbox ment to be omitted by AIM when DUPLICATE function is performed?

nlarson · Post by **nlarson** » Mon Oct 21, 2013 11:48 pm

Thanks ren, I have had a busy week and had not gotten back to testing this. Would like to know if this is working as intended.

nlarson · Post by **nlarson** » Wed Oct 23, 2013 2:24 pm

Finally got around to trying some alternate methods. Rafa that did not work for me, same issue. Support any input on this please?

Rennur · Post by **Rennur** » Wed Oct 23, 2013 10:50 pm

DUPLICATE function works as intended as long as 'Value must be provided' in child references for the parent Object is un-checked.

Maybe this re-write of Rafa's process might work as an alternative.

DUPLICATE ThisObjectives

DUPLICATE Objectives
Duplicates the current original Objective in context. 'This' prefix is not required.

FIND Deliverables WHERE Deliverables IN ThisObjetives.DeliverablesReference

DUPLICATE Deliverables EXCEPT Owner

DUPLICATE ThisDeliverables EXCEPT Owner
Duplicates the found Deliverables

ThatDeliverables.Owner=ThatObjetives

INSERT ThatDeliverables IN ThatObjectives.DeliverablesReference

nlarson · Post by **nlarson** » Thu Oct 24, 2013 1:24 am

I have a work around, but it seems to prevent the last step in the process (view Thatobject). I will post it tomorrow, just need to see if I can figure out a way to Find Thatobject, then i should be able to get it into View.

nlarson · Post by **nlarson** » Thu Oct 24, 2013 1:01 pm

Solved Using BATCHES OF. As previously noted this only applies to DUPLICATE-ing References when they are OWNED BY another BO, and the value of the child to parent where VALUE MUST BE PROVIDED is true

Code: Select all

DUPLICATE ThisObjectives 
LoggedInRegularUser.Variable_CopyID=ThatObjectives.ID 
FIND Deliverables WHERE Deliverables IN ThisObjectives.DeliverablesReference IN BATCHES OF 1 
DUPLICATE Deliverables 
ThatDeliverables.ParentReference=ThatObjectives

One issue - if you want to show the newly copied record to the user after it is created you must create a second process and store a value to RegualrUser to act as a variable input for the second process. I do not know why VIEW does not work with the above, the log show it successfully executing, however the screen does not update.

Code: Select all

Proecess #1 
DUPLICATE 
DUPLICATE ThisObjectives 
LoggedInRegularUser.Variable_CopyID=ThatObjectives.ID 
FIND Deliverables WHERE Deliverables IN ThisObjectives.DeliverablesReference IN BATCHES OF 1 
DUPLICATE Deliverables 
ThatDeliverables.ParentReference=ThatObjectives
VeiwRegualrUser_VariableCopyID 


Process #2
FIND Goals WHERE Goals.ID=LoggedInRegularUser.Variable_CopyID 
VIEW Goals

So a little cumbersome, but functional. It would be nice to know why VIEW will not work in a single process and I still think DUPLICATE TO should support OWNED BY and VALUE MUST BE PROVIDED, but I have what I need for now. Thanks all for the help!

nlarson · Post by **nlarson** » Thu Oct 24, 2013 1:06 pm

ugh... why can't we EDIT our own @#$%$%$ forum posts...

The above first sentance should read:

Solved Using BATCHES OF. As previously noted this only applies to DUPLICATE-ing Reference lists when the the Relationship is OWNED BY another bo AND the VALUE MUST BE PROVIDED option is true AND the MULTIPLE ALLOWED option is false