Need to send an email notification on weekly basis to remind project complete date to PM?

[Deepika61]

Hi All,

Actually i have requirement that  need an email notification to be sent to me on project complete  date to the project manager on weekly basis untill all stories marks as complete

And Email notification to include link to agile board 

I have idea that create a schedule job in that

1. need to check that project end date 

2. if end date not completed then need to check if stories are complete or not

3. if stories are still not complete then we need to trigger an event

These are the steps to follow, so i need schedule script to achieve this?

Please help me to achieve this 

Thanks

Deepika

[Mark Roethof]

So where is the debugging you performed?

[Mark Roethof]

Unfortunately I cannot test your code since I don't have customer_project. Though just looking at your code, what looks odd to me:

story.addEncodedQuery('project', story.project.toString());

story.project? Shouldn't this be projectEnd.project or something? 

[Deepika61]

@Mark Roethof 

"story.project? Shouldn't this be projectEnd.project or something? '

I have tried this as well, but not working

you can test with "pm_project " Instead of my table, and provide me the changes where did i goes wrong 

Thanks

Deepika

[Mark Roethof]

Also again, story.addEncodedQuery('project', story.project.toString()); looks odd.

story is the GlideRecord query to rm_story. So how can you than query story.project, that's not possible.

So what value should project be, come from, etcetera? What is your logic for this, if you try to explain it in words.

[Mark Roethof]

Or goto the rm_story table, and from the list create your filter. There copy the breadcrumb, and paste it here. That way we also see the logic that you are after.