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]

You have answered your own question. use the below query

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='';
}

[chanikya]

i have tried with that, but t is reflecting In-active user name.

[SanjivMeher]

Can you run this? Let me know, what you see in the messages if it doesn't work this time.

if (current.u_manager_number!='')
{
var gr=new GlideRecord('sys_user');
gr.addActiveQuery();
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.user_name);
current.u_manager=gr.sys_id;
}
}
else
{
current.u_manager='';
}

[chanikya]

Issue was fixed, 

It is working now...!!

Thanks for your help "Sanjiv"..!!!

[chanikya]

Thanks for your support Sanjiv,

it is resolved now....!!!!

Thank you so much SANJIV!!!