The Zurich release has arrived! Interested in new features and functionalities? Click here for more

List Collector Ignores Reference Qualifier – Script Include Not Working?

Erica2
Tera Contributor

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:

Erica2_0-1758238499053.png

 

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'
});

 

7 REPLIES 7

Hi @Erica2 ,

Make a new script include without client callable.

Sudeep5
Tera Contributor

You don't need a script include for this. You can have filter applied directly.

use the following in Reference qualifier field.

javascript: "u_active=false"

 

Please check the exact column name of active field, incase it is not 'u_active' use teh exact column name.

Ankur Bawiskar
Tera Patron
Tera Patron

@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.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader