1 ACCEPTED SOLUTION
Hello @Mark Wood
You can also use the script include and call that script include inside the variable in reference qualifier.
You can refer the below code:
Script Include:
var AssetFilterUtil = Class.create();
AssetFilterUtil.prototype = {
initialize: function() {},
getFilteredAssets: function() {
var requestedFor = current.variables.requested_for;
gs.log("REQ FOR - " + requestedFor);
var assetIds = [];
var arrayUtil = new ArrayUtil();
var assetGr = new GlideRecord('alm_asset');
assetGr.addQuery('assigned_to', requestedFor);
// assetGr.addEncodedQuery('sys_class_name=alm_hardware^ORsys_class_name=alm_consumable^install_statusNOT IN7');
assetGr.addQuery('sys_class_name', 'IN', ['alm_hardware', 'alm_consumable']);
assetGr.addQuery('install_status', 'NOT IN', [7, 8]);
assetGr.addQuery('state', 'NOT', 'retired');
assetGr.query();
while (assetGr.next()) {
gs.log("Inside while");
assetIds.push(assetGr.sys_id.toString());
}
return 'sys_idIN' + arrayUtil.unique(assetIds).join(',');
},
type: 'AssetFilterUtil'
};
Reference Qualifier:
javascript: new AssetFilterUtil(). getFilteredAssets();
Let me know your views on this and Mark ✅Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact.
Regards,
Aniket
