Copy reference field value into string field

[chanikya]

i have Group field(reference)     in KB record so when i select the group name in KB record then that group name should be upadte in KB Group field(string type) of Approval table.

[Prateek kumar]

Write an after business rule on the knowledge record table and update the approver table with the group field accordingly.

[chanikya]

Hi,

i have written script , but not working..

var one = g_form.getDisplayBox('group').value;

var approve=new GlideRecord('sysapproval_approver');

approve.addQuery(document_id, current.sys_id);

approve.query();

if(approve.next())

{

approve.u_kb_group=one;

approve.update();

}

[Prateek kumar]

See if this helps

Updated Script:

var one = current.group;

var approve=new GlideRecord('sysapproval_approver');

approve.addQuery('document_id', current.sys_id);

approve.query();

if(approve.next())

{

approve.u_kb_group=one;

approve.update();

}

g_form doesn't work server side.

[chanikya]

(function executeRule(current, previous /*null when async*/)

{

var one = current.u_group;

var approve=new GlideRecord('sysapproval_approver');

approve.addQuery('document_id', current.sys_id);

approve.query();

if(approve.next())

{

approve.u_kb_group=one;

approve.update();

}

})(current, previous);

Getting group sys_id, how can we display Group name here instead of     " Group sys_id"