Need to visible only managers in reference field on incident table.

[Mallika1]

Hello Developers!

I am trying to get only managers in reference field on incident table.

I have tried with manager is not empty condition in reference qualifier, it shows users those have managers.

But I need to get only managers in field.

Please anyone suggest me.

Thanks in advance!

[Ankur Bawiskar]

Hi,

you will have to use advanced reference qualifier for this

1) query entire sys_user table and get only the managers from manager field and return those users

Script Include:

var GetUsers = Class.create();
GetUsers.prototype = {
	initialize: function() {
	},

	getOnlyManagers: function(){
		var arr = [];
		var gr = new GlideRecord("sys_user");
		gr.addQuery("manager", "!=", "");
		gr.query();
		while(gr.next()) {
			arr.push(gr.getValue('sys_id'));
		}
		return arr.toString();
	},

	type: 'GetUsers'
};

Advanced ref qualifier:

javascript: 'sys_idIN' + new GetUsers().getOnlyManagers();

Regards
Ankur

[chandan15]

the script is taking time to execute. Performance is going down