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

Salah2
Tera Contributor

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();

 

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

like this

Remember to Save and Activate the Flow

find_real_file.png

find_real_file.png

find_real_file.png

Final Flow

find_real_file.png

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

17 REPLIES 17

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

You can use flow designer for this without any script

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

reminder emails are usually sent x days before some date field on the table.

But the notifications you require are normal notifications

so you can do this

1) flow will trigger as soon as kb record is inserted

2) it would use Do Until Logic

3) Wait for 90 days and then send email

4) The end condition would be article is expired

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

like this

Remember to Save and Activate the Flow

find_real_file.png

find_real_file.png

find_real_file.png

Final Flow

find_real_file.png

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Hi Ankur,

Correct me if I am wrong, but the 90 days count starts from the day the flow designer is activated?