ServiceNow Service Catalog Advanced Reference Qualifier in SCOPED app

observations:

• the script include is created within the scoped app but needs to be accessible from all scopes
• client callable box does not need to be ticked

example calling from the ref qual field on the catalog variable (lookup select box):

javascript:'sys_idIN' + new x_cls_clear_skye_i.ClearSkyeTableServerSide().retrieveMemberships(current.variables.account)

example calling from the ref qual field on the catalog variable (list collector):

javascript:'sys_idIN'+new x_cls_clear_skye_i.ClearSkyeTableServerSide().retrieveMemberships(current.variables.account.toString())

note the 'variable attributes' field on the variable:

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=group

(my observation is that ref_qual_elements=account causes the filter to BREAK!! So leave it out

s. ee https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0746780

also, it does not appear to be possible to pass the value of another reference variable using .retrieveMemberships(current.variables.account) but I managed to get it working using 

.retrieveMemberships(current.variables.account.toString())

seems necessary to click the 'run filter' button on the list collector to pull back the results

)

example script include code 1 - simple example:

var ClearSkyeTableServerSide = Class.create();

ClearSkyeTableServerSide.prototype = {

initialize: function() {},

retrieveMemberships: function(acc) {

var aReturnVals = [];

aReturnVals.push('775fafa697e5ad10df843a300153afb6');

aReturnVals.push('9aaf672a97e5ad10df843a300153af0b');

return (aReturnVals);

},

type: 'ClearSkyeTableServerSide'

};

example script include code 2 - using a glideRecord:

retrieveMemberships: function(acc) {

//gs.warn('acc=' + acc + '::ClearSkyeTableServerSide.retrieveMemberships');

var aReturnVals = [];

var grAc = new GlideRecord('x_cls_clear_skye_i_account');

grAc.addQuery('sys_id', acc);

grAc.query();

if (grAc.next()) {

var grMem = new GlideRecord('x_cls_clear_skye_i_m2m_groups_ilm_objects');

grMem.addQuery('ilm_object', grAc.sn_object_id);

grMem.query();

while (grMem.next()) {

aReturnVals.push(grMem.sys_id+'');

}

} else {

gs.warn('REC NOT FOUND::ClearSkyeTableServerSide ['+acc+']');

}

return (aReturnVals);

},