Hi,
Please find the steps below to achieve your requirement:
1) Create a Scheduled Job whose frequency will be as "Daily" and use the script as below to trigger a Notification containing all Short Description for Knowledge articles which are about to expire as shown below:
triggerNotificcation();
function triggerNotificcation(){
var shortArr = [];
var gr = new GlideRecord('kb_knowledge');
gr.addEncodedQuery('workflow_state=published^valid_to<javascript:gs.beginningOfThisQuarter()');
gr.query();
while(gr.next()){
shortArr.push(gr.short_description.toString());
}
gs.eventQueue('Event Name',gr,shortArr.toString()); Replace "Event name" with your Event Name and also you can pass 4th parameter after "shortArr" in last line in case you want to send this Notification to a specific user as well
}In script above you also need to create an event first by navigating to "Registry" module as shown below and select Table as Knowledge:
Now Navigate to Notification Script module where you need to fetch the value passed from Scheduled Job and retrieve it in your Email Script and print it in a single Notification itself as required.
Navigate to Email Script as shown below:
Use the script below to retrieve All Short Description into Single Email as shown below:
(function runMailScript(/* GlideRecord */ current, /* TemplatePrinter */ template,
/* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action,
/* Optional GlideRecord */ event) {
// Add your code here
var getshort = event.parm1;
var getSplitShort = getshort.split(',');
for(var i=0;i<getSplitShort.length;i++){
template.print('Knowledge Short Description is ' + getSplitShort[i]);
}
})(current, template, email, email_action, event);
Now the final step will be to configure your Notification as shown below which should be on Knowledge Table and should be Event Based and make sure to check "Parm1 and Send to Event Creator" as True and to call the Notification Email script in your Notification you need to use the syntax below:
${mail_script:Mail Script Name}
Let me know if you are stuck.
Hope this helps. Please mark the answer as correct/helpful based on impact.
Regards,
Shloke
