Approver for a change task

drichter
Kilo Contributor

We need to have approvers for change tasks. I have copied the change_request workflow and modified it for change_task, but nothing is written to sysapproval_approver table. I have a field u_task_approver in change_task that is a reference to the sys_user table.
I have research extensively the wiki, approval engines, business rules to learn how the change_request approval request is added to the Approver table (Sysapprover_approver) in order to do the same for a change_task approver.
I have also tried all three choices for the approval engine for change_task, with no difference.

I have also created new work flow from routine change request for routine change task,
changed table, checked for anything else to change,
and published !

Default stages by table does not reference the beginning of any work flows,
And the script in the work flow references "current", implying it is already working in the approval table.


it remains a mystery how the record is getting inserted into the approver table by the change_request, so that I can do the same for change_tasks

8 REPLIES 8

drichter
Kilo Contributor

Thank you ! The workflow activity was the missing link.
I added the activity Approval-User to the workflow, in place of the Manager-approval that was there for change_requests, then modified the activity, calling it Change Task Approval, to use the u_task_approver as the user, condition: task tyoe is change task.
that user now gets the approval requests.


drichter
Kilo Contributor

This should probably be a new item but Chris has been so helpful I'll start here (after I exhausted my co-workers).

Now that I get the Change_task approver inserted, I need to send an email to that approver to let him know it is there for her to approve or reject.
But I am not getting any email logged for the event and the email notification.

The approver I select does get email logged for other events.

The event is happening according to the event log.
change_task.approval.inserted
(so my understanding is a B Rule is not needed, since the event is already getting created)

the approval for the user shows up in "my approvals"

my email notification for that event is
change task approval request

table is Approval

I have tried it with various conditions:
Approval is not empty
And
No conditions at all

User field is Approver
I added an explicit "User", diane Parham, to see if that helped, and if she would be sent email. Still no email logged.

It is active.

I have tried it with mandatory on, and off.

I have tried it with an email template, and without an email template.

I have changed subject and message to plain text.

But according to the email logs it never sends the email

No errors.
Debug showed nothing.

Any suggestions ?

Thank you.


So it looks like you have a change_task.approval.inserted event, but do you have a notification tied to that event. The normal approval emails fire on the approval.inserted event.


drichter
Kilo Contributor

yes:
"my email notification for that event is
change task approval request"