PSA: Workflow Approvals & SQL-based Status Changes
- Lindsay O'Connell
- Mar 18
- 1 min read
When an EAM status is changed using SQL and an approval workflow exists for it, EAM will NOT automatically create the approval event.
To generate the approval event, we need to call the native EAM procedure O7SETWORKFLOW right after the status change SQL statement.
This is a key consideration if you’re looking to implement Approval Workflows and any of your processes rely on automatic status changes which are carried out by Flex Business Rules, Alert Management, or other SQL-based configurations.
If you would like any assistance configuring Approval Workflows as well as updating your existing SQL to include this important step, don’t hesitate to let us know!
Tech Wheelhouse, LLC
留言