How to send notification reminder to update Knowledge articles every 90 days?

[Salah2]

Hello,

We are trying to get Kb article authors to update publication every 90 days.  

We did not see anything OOB that would allows to do send notification 90 days after Kb article is 'published', but we found Scheduled Script Execution: Notification for Article Expiry Warning. 

Is it possible to modify the script below to lookup the 'published date' instead of 'expired date'? I am new to this, i will greatly appreciate any help.  thanks.  

Condition:

answer = false;
if (gs.getProperty("glide.knowman.enable_article_expiry_notification", "false")==="true") {
    var gr = new GlideRecord('kb_knowledge');
    gr.addEncodedQuery('workflow_stateINpublished^valid_toONNext month@javascript:gs.beginningOfNextMonth()@javascript:gs.endOfNextMonth()');
    gr.query();
    answer = gr.next();
}

Run this script:

new KBKnowledge().notifyForExpiringArticles();

[Salah2]

Is it possible to modify this flow so that notification is sent 

If 

Workflow = Published

Updated < Published [Updated date is less than or equal to Published date]

Updated <   Current date 

- Sending an email might not be enough to confirm the author has received their article.  

I am not quite certain if this is the best practice: we were going to require the authors to checkout the articles for review, because that way new updated date will be generated.  

[Ankur Bawiskar]

Please test it once.

[Salah2]

First I tried testing your first recommendation, but something does not seem right. 

Please see wait time

This is the flow designer i created 

[Ankur Bawiskar]

So did you run the flow and check what happens?

[Salah2]

Hi @Ankur Bawiskar , 

In the body of the email KB number is included - Do you know how I can turn from text into a hyperlinked number?

 

I created Action below, and it is working fine for other modules.  However, i could not get to work for kb_knowledge.  You have any suggestion what i could do to modify it? 

Script from Actions 

(function execute(inputs, outputs) {
  var gr = new GlideRecord('sysapproval_approver');
  gr.get(inputs.approval);
  
  var instance_name = gs.getProperty('instance_name') 
 
  outputs.url1 = '<a href = "https://' + instance_name + '.service-now.com/sp?id=approval&table=sysapproval_approver&sys_id=' + gr.sys_id + '">' + gr.sysapproval.number + '</a>';

})(inputs, outputs);