Display reference field value into string fields

[Kishore8]

My script is not working:

var one = current.u_group.getDisplayValue();

var gr=new GlideRecord('sysapproval_approver');

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

gr.query();

if(gr.next())

{

gr.u_kb_group=one;

gr.update();

}

[Shishir Srivast]

Can we try with after insert BR on sysapproval_approver table with below code.

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

var gr = new GlideRecord('kb_knowledge');

gr.get(current.sysapproval);

current.u_kb_group = gr.getDisplayValue('u_group');

})(current, previous);

with Condition

[Kishore8]

Hi Shishir,

Thanks to your reply....!

I will check and get back to you

[Kishore8]

Hi shishir,

It is not working....!!!

Table: sysapproval

var gr = new GlideRecord('kb_knowledge');

gr.get(current.sysapproval);

current.u_kb_group = gr.getDisplayValue('u_group');

[Shishir Srivast]

Can you put some logs and check if it logs anything

gs.log('INKB');

var gr = new GlideRecord('kb_knowledge');

gr.get(current.sysapproval);

gs.log('KB Number' + gr.number);

gs.log('u_group' + gr.getDisplayValue('u_group'));

current.u_kb_group = gr.getDisplayValue('u_group');

[Kishore8]

Not getting any result.

I think , when we change group value in KB record   that value should be copy into KBApproval table right.?