Looking for some assistance on an issue with blank emails.
Created 2 new tables as extensions of the Task table and they are CCR (a specific type of request) and CCT (any tasks associated with that request).
The requirement is to send an email notification to the CCR requester, 3 days after a specific CCT task state changes to Pending.
A client script has been configured to set a reminder date field on that CCT, whenever the state changes to Pending.
Created a scheduled job to run periodically (for testing purposes currently set to every 10 min) and when the conditions within the script are met, it triggers an event and sets a reminder sent flag on the CCT.
The event runs on the CCR table and is being used to send an email notification to the requester.
The notification is running against the CCR table and is correctly sent to the requester when the conditions are correct, using an email template.
This template is also using the CCR table.
The issue experienced is that information is missing from the email message being sent.
The number and opened_at fields are empty within the email message sent.
The URI_REF ends up pointing to the scheduled job and not the actual CCR.
Also tried leaving the email template empty and have it call an email script, but the number and opened_at are also blank within the email sent.
We are on Fuji Patch 13 Hotfix 1.
Any ideas on what the issue may be and the best approach to achieving the requirements, are greatly appreciated?
As always, any assistance is greatly appreciated.
Cheers,
Ron
