List Collector Ignores Reference Qualifier – Script Include Not Working?

[Erica2]

Hellow,

I'm currently trying to learn how to properly call a Script Include from a List Collector variable's Reference Qualifier.

However, it seems that the list still returns data regardless of whether the Reference Qualifier is calling the Script Include or not.

Could someone please review my code and let me know where I might have gone wrong? Thank you!

List Collector Variable:

Script Include: - It should only return a few inactive records if it is working correctly.

var SoftwareName = Class.create();
SoftwareName.prototype = Object.extendsObject(AbstractAjaxProcessor, {

    getSoftwareNameRefQual: function() {
        var gr = new GlideRecord('u_software_inventory');
        gr.addQuery('active', false);  // Only inactive records
        gr.query();

        var softwareNames = [];

        while (gr.next()) {
            var name = gr.getValue('u_software_name');
            if (name)
                softwareNames.push(name);
        }

        return softwareNames.join(',');
    },

    type: 'SoftwareName'
});

[Ankur Bawiskar · Accepted solution]

@Erica2 

why you require script include?

what do you mean by few records? how many 5 or 10 or 100?

you can directly form the encoded query and copy paste there

javascript: 'u_active=false';

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Rafael Batistot]

Hi @Erica2 

Try this: 

function onLoad() {
  var myListCollector = g_list.get("<name_of_list_colector>");
  myListCollector.reset();
  myListCollector.setQuery('active=false');
}

https://www.servicenow.com/community/developer-forum/can-list-collectors-be-filtered-in-the-service-...

[Sarthak Kashyap]

Hi @Erica2 ,

1st of all please try to call script include like this :

javascript: new global.softwareName().getSoftwareNameRefQual();

2nd thing I made changes in your return statement please verify that

var SoftwareName = Class.create();
SoftwareName.prototype = Object.extendsObject(AbstractAjaxProcessor, {

    getSoftwareNameRefQual: function() {
        var gr = new GlideRecord('u_software_inventory');
        gr.addQuery('active', false);  // Only inactive records
        gr.query();

        var softwareNames = [];

        while (gr.next()) {
            var name = gr.getValue('u_software_name');
            if (name)
                softwareNames.push(name);
        }

        return "nameIN"+softwareNames.join(',');
    },

    type: 'SoftwareName'
});

Please mark my answer correct and helpful if this works for you

Thanks,

Sarthak

[Sarthak Kashyap]

javascript; new global.softwareName().getSoftwareNameRefQual();

Also make sure your script include is not client callable.

[Erica2]

Hi @Sarthak Kashyap ,

I followed your suggestion and made all the necessary changes.

However, it's still returning all records. For testing purposes, it should only be returning a few inactive records if it's working correctly.

javascript; new global.softwareName().getSoftwareNameRefQual();