Related List - Hierarchy of Managers

[vidhya_mouli]

Hi, 

I have to create a custom related list, where Manager Hierarchy (Manager > Manager's manager and so on) should be displayed.

Relationships:

My Code:

(function refineQuery(current, parent) {
	var employeeID = parent.u_reference_1;
	var managerID = employeeID.manager;
	var level = 0;
	gs.addInfoMessage("ManageID: " + managerID);
	
	while (managerID != null && managerID != '') {
		current.addQuery("sys_id", managerID);
		employeeID = managerID;
		managerID = employeeID.manager;
		
		gs.addInfoMessage("ManageID: " + managerID);
	} 
})(current, parent);

Output:

 

All the manager's sys_ids are getting displayed (gs command). However, nothing is getting added to the related list. What am I missing here?

[Vasantharajan N · Accepted solution]

@vidhya_mouli - Please try the below code and let us know the result.  Your code's while loop simply adds AND condition of manager's sysid which is causing the problem. 

(function refineQuery(current, parent) {
    var employeeID = parent.u_reference_1;
    var managerID = employeeID.manager;
    var level = 0;

    var managerStsids = getManagerIDs(employeeID, managerID);
    current.addEncodedQuery("sys_idIN" + managerStsids);

    function getManagerIDs(employeeID, managerID) {
        var managers = [];
        while (managerID != null && managerID != '') {
            if (managerID != null & managerID != '') {
                managers.push(managerID.toString());
            }
            employeeID = managerID;
            managerID = employeeID.manager;
        }

        gs.addInfoMessage("ManageIDs are : " + managers.join());
        return managers.join();

    }
})(current, parent);

[vidhya_mouli]

Thank you. it worked.