Name
global.getExcludeLibrariesFromListExp
Description
No description available
Script
function getExcludeLibrariesFromListExp(targetTableName) {
var patternGr = new GlideRecord('sa_pattern');
patternGr.addQuery('cpattern_type','2');
var sysIDs = [];
var gr = new GlideRecord(targetTableName);
gr.query();
while (gr.next()) {
var libsArray = gr.lib_list.split(",");
for (var i=0; i < libsArray.length; i++) {
if(libsArray[i].length>0)
sysIDs.push(libsArray[i]);
}
}
patternGr.addQuery('sys_id', 'NOT IN', sysIDs);
return patternGr.getEncodedQuery();
}Sys ID
578766cb675032009e052dbd2685ef39