Skip Navigation Links.
Introduction to Novo Solutions
Upgrade Guides
Novo Documentation Library
Usage Guides
All About Searches
Software Admin's Guide
Asset Management Guide
Knowledge Management Guide
Request Management Guide
Request Management Administrator's Guide
Request Management End User's Guide
Novo Mail Service Guide
Using WorkFlows
Using the Report Writer
Frequently Asked Questions (FAQs)
Video Library
Issues
Release Notes

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
      • USER_REF=FromUserId
    • If FromUserId is null
      • USER_REF=0
    • 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
        • USER_REF=FromUserId
      • If FromUserId is null
        • USER_REF=0
      • 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
        • USER_REF=FromUserId
      • If FromUserId is null
        • USER_REF=0
      • NOTE_INTERNAL=1
    • Notify WF_TASKS.USER_REF_ASSIGNED