How to Display Manager name based on Manager ID number - Business Rule

[chanikya]

i have written BR  script for it, it is working fine for Existing users,

but when i created one new record in user table then   manger name is not reflected based on manager ID number , after created user if i updated any field then it is reflecting manger name.

Thread:  My request is here it should reflecting for New records & Existing records

BR Script:    Before,        inset, update

if(current.u_manager_number=='')
{
current.u_manager= '';
}
else{
var gr=new GlideRecord('sys_user');
gr.addQuery('employee_number',current.u_manager_number);
gr.query();
while(gr.next())
{
current.u_manager=gr.sys_id;
}
}

Manager field is Read only here.

[SanjivMeher · Accepted solution]

Try this script

if (current.u_manager_number!='')
{
var gr=new GlideRecord('sys_user');
gr.addQuery('employee_number',current.u_manager_number);
gr.query();
gs.addInfoMessage('+++++++current.u_manager_number+++++++'+current.u_manager_number);
if(gr.next())
{
gs.addInfoMessage('+++++++current.u_manager_number+++++++'+gr.sys_id);
current.u_manager=gr.sys_id;
}
}
else
{
current.u_manager='';
}

[chanikya]

Okay, Let me try it please.

[chanikya]

Hi Sanjiv,

Thanks Sanjiv..!!!

it is working now, some times it is not reflecting but when we use   gr.addQuery('active', 'true'); then working fine.

with same Manager ID number -  one record is in ''True'',    one record  is in ''False'';

if (current.u_manager_number!='')
{
var gr=new GlideRecord('sys_user');
gr.addQuery('employee_number',current.u_manager_number);
gr.addQuery('active', 'true');
gr.query();
gs.addInfoMessage('+++++++current.u_manager_number+++++++'+current.u_manager_number);
if(gr.next())
{
gs.addInfoMessage('+++++++current.u_manager_number+++++++'+gr.sys_id);
current.u_manager=gr.sys_id;
}
}
else
{
current.u_manager='';
}

[SanjivMeher]

That's great. can you please mark the answer correct if it worked for you.

[chanikya]

Hi Sanjive,

Can we populate Only Active User name only  in Manager field

with same Manager ID number -  one record is in ''True'',    one record  is in ''False'';

some time it is displaying  In-active user name in Manager field.  

So please help me here , need to display only Active user name in Manager field