Unable to Call script include in filter condition

[Ganesh Palve]

PFB Script include

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

	ApprovalNotCome : function (){
	var arr =[];
var gr = new GlideRecord('sys_user');
gr.addEncodedQuery('roles=approver_user');
gr.query();
while (gr.next()) {
    var gr1 = new GlideRecord('sysapproval_approver');
    gr1.addQuery('approver.name', gr.getValue('name'));
    gr1.query();
    if (!gr1.next()) {
        arr.push(gr.getValue('name'));
    }
}
gs.log("my error - "+arr);
   return arr;
},

    type: 'Test'
};

and I am calling above script include like below - javascript: new global.Test().ApprovalNotCome();

but not able to get values in filter?? please help here 

Thank in advance

[zubairs]

Thanks so much! Your solution worked perfectly for me. Really appreciate you taking the time to share your knowledge with the community! 💌

[d_17]

Hi @Ganesh Palve 

Try running this in background script. 

    var arr =[];

var gr = new GlideRecord('sys_user');

gr.addEncodedQuery('roles=approver_user');

gr.query();

while (gr.next()) {

    var gr1 = new GlideRecord('sysapproval_approver');

    gr1.addQuery('approver.name', gr.getValue('name'));

    gr1.query();

    if (!gr1.next()) {

        arr.push(gr.getValue('name'));

    }

}

gs.print("my error - "+arr);

Check if you getting any names when you run it? I ran on my instance and i am getting value 

[Bert_c1]

@Ganesh Palve 

I verified your script include works and that it is not called when used in the filter condition you posted on the sys_user table.

I suggest you read:

https://docs.servicenow.com/bundle/xanadu-platform-user-interface/page/use/using-lists/concept/c_Fil...

and find a Filter type that works for your case.