Get the topmost parent from a parent child relationship (business unit)

[anirban300]

Hello All,

I want to fetch the topmost parent business unit and set it in the user table. I am stuck in between with the below after insert/update business rule.

1. In the user table there is a filed called "Department". 

2. Every "Department" has a "Business Unit" associated with it.

3. Every "Business Unit" has a parent "Business Unit" set in the "Parent" field.

4. We have created a custom string field "Business Unit" on the user table.

5. On change of department, the topmost parent "Business Unit" should be set.

I have written the below after business unit on the user table, but it's limited to fetch only the first parent. Can someone help me in fetching the topmost parent from the business unit table?

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

var gr = new GlideRecord('cmn_department');
gr.addQuery('sys_id', current.u_d);
gr.query();
while (gr.next()) {
var bu = gr.business_unit;
var grb = new GlideRecord('business_unit');
grb.addQuery('sys_id', bu);
grb.query();
while (grb.next()) {
var parent = grb.parent;
current.u_business_unit = prent.name;
}
}
current.update();
})(current, previous);

[Community Alums]

@AnubhavRitolia This is returning Undefined value

[SanjivMeher]

Please have the courtesy to mark other answers as helpful at least. The script, which was marked answered was the same script I posted was just copied and edited. And the edited script also returns sysid instead of business unit while you have a string field. How did it work for you?