You can accomplish this with a notification policy. Create a query that retrieves the due tasks and let the notification policy then send an email to the assigned worker.

Hi,

Here is a query you can use:



select workitem_number,workitem_title,assigned_to_worker_name,assigned_to_worker_email,contact_name,contact_phone

from HD_workitem_current_view

where workitem_status_lookup_id <> 600 and workitem_is_scheduled = 1 and

DateAdd(d,-1,CAST(Floor(CAST(workitem_start_on AS FLOAT)) as Datetime)) = CAST(FLOOR(CAST(GETDATE() AS FLOAT)) as datetime)



The -1 means that all tasksdue to be started tomorrow will be returned. You can change this to any number you like.

Set the rest of your polcy up accordingly. All that CAST and FLOAT stuff is just to get rid of the time portion of the date.



Dan

I'm trying to do something similar with our setup.  I want to make a NS Task Notification Policy to check everyday and if a ticket is idle in the "Pending User" status I want the system to email the contact of the ticket to request them to update the ticket.

I created the NS notification policy for it and have the query, but I want to have it fire off a Helpdesk email template.  The email action in the NS notification policy looks very basic and doesn't look to allow the complexity that the helpdesk system offers.  Any ideas on how to accomplish this?