|
UpdateTask If Email Subject does not contain WF_TASKS.SECURITY_TOKEN - Log Error (i.e. Cannot Update Task Security Token is Invalid)
- End UpdateTask
INSERT INTO WF_NOTES - TASK_REF=Task Id Extracted from subject
- NOTE_DATE= GetDate()
- NOTE_DESCRIPTION=Body
- If FromUserId is not null
- If FromUserId is null
- NOTE_INTERNAL=0
If Subject Contains Complete Keyword specified in Task Complete Keyword - UPDATE WF_TASKS
- STATUS_REF=2
- TASK_EDIT_METHOD=3 (for Novo Mail Service)
- TASK_EDIT_MAILFROM=To
- INSERT INTO WF_NOTES
- TASK_REF=Task Id Extracted from subject
- NOTE_DATE= GetDate()
- NOTE_DESCRIPTION=Status update From: PrevVal To:Completed
- If FromUserId is not null
- If FromUserId is null
- NOTE_INTERNAL=1
- Notify WF_TASKS.USER_REF_ASSIGNED
If Subject Contains Reject Keyword specified in Task Reject Keyword - UPDATE WF_TASKS
- STATUS_REF=3
- TASK_EDIT_METHOD=3 (for Novo Mail Service)
- TASK_EDIT_MAILFROM=To
- INSERT INTO WF_NOTES
- TASK_REF=Task Id Extracted from subject
- NOTE_DATE= GetDate()
- NOTE_DESCRIPTION=Status update From: PrevVal To:Rejected
- If FromUserId is not null
- If FromUserId is null
- NOTE_INTERNAL=1
- Notify WF_TASKS.USER_REF_ASSIGNED
|