question Re: Function is not working in Scheduled Job in Developer forum

Function is not working in Scheduled Job

Amrutha K V — Tue, 12 Sep 2023 14:47:33 GMT

Hi Team,

I am using the below script for removing inactive users who is updated on last week from knowledge base table.
It is working without using function. But our requirement is to use the Knowledgebase function for removal of inactive users from kb table separately by calling the same inActiveUsers array inside the function. I tried the below script with function but it's not working. Could you please help me. Thank you!!

Note: We have to remove the inactive users from other tables(Assignment Data Lookups,Report,Scheduled Email of Report,Notification) also by mentioning different function for each table.

var inActiveUsers = [];

var gr1 = new GlideRecord('sys_user');

gr1.addEncodedQuery('active=false^sys_updated_onONLast week@javascript&colon;gs.beginningOfLastWeek()@javascript&colon;gs.endOfLastWeek()');

gr1.query();

while (gr1.next()) {

inActiveUsers.push(gr1.sys_id.toString());

}

function knowledgebase(inActiveUsers) { ------->1:This function is not working for me.

gs.log("success111");

if (inActiveUsers) {

gs.log("success1");

for (var i = 0; i < inActiveUsers.length; i++) {

gs.info("inActiveUser[i]" + inActiveUsers[i]);

var kbase = new GlideRecord('kb_knowledge_base');

kbase.addEncodedQuery('kb_managersLIKE' + inActiveUsers[i]);

kbase.query();

var mgr = [];

while (kbase.next()) {

mgr = kbase.kb_managers.toString().split(',');

gs.log("kbase.kb_managers" + kbase.kb_managers);

for (i = 0; i < inActiveUsers.length; i++) {

for (j = 0; j < mgr.length; j++) {

if (mgr[j] == inActiveUsers[i]) {

var remove = mgr.indexOf(mgr[j]); // get the position of the element to be removed

mgr.splice(remove, 1); // remove the element from the array

}

kbase.kb_managers = mgr.toString();

gs.log("BalanceAfterRemoval" + kbase.kb_managers);

kbase.autoSysFields(false);

kbase.update();

}

Re: Function is not working in Scheduled Job

Bert_c1 — Tue, 12 Sep 2023 14:55:22 GMT

Hi Amrutha,

I don't see where you call the function in the script.

add "knowledgebase(inActiveUsers);" After the while loop.

Re: Function is not working in Scheduled Job

Amrutha K V — Tue, 12 Sep 2023 15:07:01 GMT

Hi Mega,

I tried to add "knowledgebase(inActiveUsers);" after while loop but its not working. Inactive users who is updated on last week in kb_managers field is not getting removed.

Thank you!

Re: Function is not working in Scheduled Job

Harish Bainsla — Tue, 12 Sep 2023 15:09:54 GMT

var inActiveUsers = [];
var gr1 = new GlideRecord('sys_user');
gr1.addEncodedQuery('active=false^sys_updated_onONLast week@javascript&colon;gs.beginningOfLastWeek()@javascript&colon;gs.endOfLastWeek()');
gr1.query();
while (gr1.next()) {
inActiveUsers.push(gr1.sys_id.toString());
}

// Call the knowledgebase function with the inActiveUsers array
knowledgebase(inActiveUsers);

Re: Function is not working in Scheduled Job

Harish Bainsla — Tue, 12 Sep 2023 15:23:29 GMT

if my code help you please accept solution

Re: Function is not working in Scheduled Job

Amrutha K V — Tue, 12 Sep 2023 15:30:30 GMT

Hi Harish,

Its working now. Thank you for your quick help.
In similar manner I have tried for assignment data lookup table, but it's not working.
Could you please help as this as well. It would be great helpful.

function assignmentDataLookUp(inActiveUsers) {

if (inActiveUsers) {

for (var m = 0; m < inActiveUsers.length; m++) {

var rec = new GlideRecord('dl_u_assignment');

rec.addEncodedQuery('assigned_toLIKE' + inActiveUsers[m]);

rec.query();

while (rec.next()) {

if (inActiveUsers[m] == rec.assigned_to.sys_id) {

rec.assigned_to = '';

rec.autoSysFields(false);

rec.update();

}

assignmentDataLookUp(inActiveUsers);

Thank you!!

Re: Function is not working in Scheduled Job

Harish Bainsla — Tue, 12 Sep 2023 15:35:05 GMT

ok sure but please accept solution if my code help you and for another one post question again i try to give answer

Re: Function is not working in Scheduled Job

Amrutha K V — Tue, 12 Sep 2023 15:37:45 GMT

Okay Sure I will. Thank you!!