script to populate based on user name selection to populate manager to manager of manager to ceo

[ARAVIND22]

@Ankur Bawiskar  / @Community Alums / friends please help me

I have one reference field and one multiline text

If I select any user in reference table

It should display from my manager to top level manager upto end of manager of manager level

Please give the script to achieve this

If i select A user in reference field

in B multiline text I have to populate in list view of manager of manager level value

A->Manager->manager->manager->manager->manager->manager->manager->upto end of manager that is CEO name i have to display please help

[Janhavi Jaygade]

Hi,
You can create before business rule with the following script : 

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

var description = [];
var description_user = [];
var user = current.u_assigned_to;
var flag, i;
do {
var gr_user = new GlideRecord('sys_user');
gr_user.addQuery('sys_id', user);
gr_user.query();
if (gr_user.next()) {
if (gr_user.manager != '') {
flag = 0;
description.push(gr_user.manager);
user = gr_user.manager;
} else {
flag = 1;
}
}
} while (flag == 0);

for (i = 0; i < description.length; i++) {

var gr_username = new GlideRecord('sys_user');
gr_username.addQuery('sys_id', description[i]);
gr_username.query();
if (gr_username.next()) {
description_user.push(gr_username.name);
}
}
current.description = description_user.toString();

})(current, previous);
I hope you find this helpful!!