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 need an onchange client script and perform query on user table as u are doing on business rule

[chanikya]

Hi Sanjiv,

Onchange means here we not changing particular field. so then what based we can use it here.

Can you please suggest me here . 

i hope you understand my problem here , i can give more information.

Ex:  i am creating new user -JOHN  ,  i have filled all details including Manager Number submitted user form . now it is created as a user record , if we see it now Manager name is not reflected.   now if i updated any one of field then  immediately manager name was reflected.

[SanjivMeher]

Ok. Can you add a gs.addInfoMessage(current.u_manager_number); after the gr.addQuery script and let me know, if you see the manager number in the message box?

[chanikya]

Yes, i can see it here,   

So times some new User records are imported from CVS files also