k1000 Due date warning ticket rule with email
I just want to create a rule that emails the ticket owner and submitter when a process ticket is due.
I am setting up a Process that creates child tickets for Projects ie. for each stage of a project, a ticket is created with a due date to track each step of the project.
I am trying to modify the Overdue ticket rule to do this but I am not a SQL writer so I am a bit confused.
Any help is appreciated. I looked here and I didn't find anything that made sense to me that would do what I am hoping.