How to send reminder after 14 days if task is open

[Dasari Srihari]

Hi All,

I need to send notification for opened Catalog Tasks after 14days only one time. I have created variable called reminder(Checkbox variable) after 14days we need set this value true same time we need to send notification,

i need to send notification to assignment group, 

Please find my script below:

var task = new GlideRecord("sc_task");
task.addEncodedQuery('request_item.cat_item=36db14d8db7043005eb551b0cf96196a^stateIN-5,1,2');
task.query();

while (task.next())
{
var text = task.request_item.variables.reminder;

if(text == ' '){

task.text = true;
task.update();
//gs.eventQueue('Test');
}


}

[Ankur Bawiskar]

@Dasari Srihari 

why not use boolean field true/false instead of incrementing the count?

It would be easier to update

After send email you can update the flag as true.

If my response helped please mark it correct and close the thread so that it benefits future readers.