How to write Advanced reference qualifier & Script Include

[Mi4]

Hi,

I want to set a person who belongs to the same department as the applicant's department.

But it returns an error..

What's wrong?

Script Include:

var getMyDepartments = Class.create();

getMyDepartments.prototype = {
 initialize: function() {},

getDepartmentUsers: function() {
 var usersList = "sys_idIN";
 var grUser = new GlideRecord('sys_user');

grUser.addQuery('company', gs.getUser().getCompanyID());
 grUser.addQuery('department', gs.getUser().getDepartmentID());
 grUser.query();

while (grUser.next()) {
 usersList = usersList + ',' + grUser.sys_id;
 }
 },
 type: 'getMyDepartments'
};

variable Reference qualitifier:

System log:

Regards,

[Ankur Bawiskar]

Hi,

are you running this in scoped application? also both the field and script include is in same scope

can you change the script include name to this getMyDepartments1 and update code as below

you were not returning the usersList from script include

var getMyDepartments1 = Class.create();

getMyDepartments1.prototype = {
 initialize: function() {},

getDepartmentUsers: function() {
 var usersList = [];
 var grUser = new GlideRecord('sys_user');

grUser.addQuery('company', gs.getUser().getCompanyID());
 grUser.addQuery('department', gs.getUser().getDepartmentID());
 grUser.query();

while(grUser.next()) {
 usersList.push(grUser.getUniqueValue());
 }

return 'sys_idIN' + usersList;

 },
 type: 'getMyDepartments1'
};

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Mi4]

Hi.

Thank you for reply.

Yes, both are in the same scope application.

And, again returns the same error.

[Ankur Bawiskar]

Hi,

you should remove client callable checkbox;

also use this javascript: new getMyDepartments1().getDepartmentUsers();

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Mi4]

Hi,

Again error..