Hi Experts
I need to create a User Reference field (could be a lookup select box too), where I should list only the users that comes from a related list in the user record.
This related record is showing all the users reporting under the current user.
So, the Catalog Item form should show all those user to pick one.
In this example, 563 users reports directly or indirectly to the current user. I need the Catalog Item from to show all these users in a reference variable named "Staff" for the Requested For user.
I am not super expert in the scripting. I revised the relationship record
Named "Users Reporting Under:"
(function refineQuery(current, parent) {
// Add your code here, such as current.addQuery(field, value);
var listOfUsers = new UsersReportingTo();
var answer = listOfUsers.report(parent.sys_id);
current.addQuery('sys_id','IN', answer.toString());
})(current, parent);UsersReportingTo Script Include:
var UsersReportingTo = Class.create();
UsersReportingTo.prototype = {
report:function(userSys_id){
var Mainlist = [];
var UsersList = [];
var gr = new GlideRecord("sys_user");
gr.addQuery("active",true);
if (userSys_id.toString().length == 32)
{
gr.addQuery("manager", userSys_id);
}
else
{
gr.addQuery("manager.name", userSys_id);
}
gr.query();
while (gr.next()) {
UsersList.push(gr.sys_id.toString());
}
Mainlist = UsersList;
do{
var gr1 = new GlideRecord("sys_user");
gr1.addQuery("manager", "IN", UsersList);
gr1.query();
UsersList = [];
while (gr1.next()) {
UsersList.push(gr1.sys_id.toString());
Mainlist.push(gr1.sys_id.toString());
}
}while(UsersList.length>0);
return Mainlist;
},
type: 'UsersReportingTo'
};Yet, I can't figure out how to list all those users in the reference field using a reference qualifier.
I tried to set a refqual: javascript: new global.UsersReportingTo().userSys_id(current.variables.requested_for);
That didn't work I get ALL sys_users users.
Any help would be greatly appreciated.
