Simple way for duplicate a record

[xif1]

Hello everyone,

Is it a way for duplicate a record easily ?

I means without copying each field ?

Actually I use this method

current.start_date = 'NULL';
current.end_date = 'NULL';
current.calendar_duration = 'NULL';
current.opened_at = current.opened_at;
current.opened_by = current.opened_by;
current.sys_created_on = current.sys_created_on;
current.sys_created_by = current.sys_created_by;
current.insert();

But my record have a lot of field, and It can be very long...

[harikrish_v]

can you share the rest of the code if possible pls.

[xif1]

You've the entire piece of code.

But it seems to be cause by an other thing because now my ui action is not active

[harikrish_v]

ok fine

[marcguy]

make sure there aren't any actions with duplicate action_name in that table....

[jstoneiii]

Create a new System UI Action

doInsertAndStayRequest();
function doInsertAndStayRequest() {
var saveMe = current;
var orig_sys_id = current.getValue('sys_id');
var orig_number = current.getValue('number');
current.number = ""; // generate a new number
current.state = 1;
current.insert();
gs.eventQueue("task.insert", current, orig_sys_id, current.sys_id);
current.work_notes = "Cloned from Ticket: " + orig_number;
gs.addInfoMessage("Cloned from Ticket: " + orig_number);
Packages.com.glide.ui.SysAttachment.copy(current.getTableName(), orig_sys_id, current.getTableName(), current.sys_id);
current.update();
action.setRedirectURL(saveMe);
}