Skip to content

Feature: Send an Email to the User Locking a Record

Release Date: 1/26/2023
Versions: Elliott V8.5 and Above

Background

Some Elliott tasks, like COP Order Entry / Change Order, will cause a record to be locked while the task is executing.  Subsequently, another user will start a task, like COP Order Entry / Print Order Acknowledgement, that will also need to temporarily lock the same record.  When that happens, the second user will see a record locked message on the screen like this, with a locked record message in the status area::


There is an Elliott event that can be subscribed to that can send an email detailing the locked record conflict to an administrator, once per minute, until the record is released by the first user.  With this update, Elliott has the ability to send an email to the first user, the one who is locking the record, as well.  This could help resolve the conflict sooner because the offending user will get notified that he/she has a record locked that is causing a conflict.

Subscribing to the Record Locked Event

To send an email to the offending user, go to Utilities / Global Setup, click on the Events button, press F5 and select the event with LCKEVENT in the Type column:


Select the E-mail and Recurring Request options on the General tab, then select the E-mail tab.  Click on the To: field, right-click and select the choice System Variables / Email by Windows UserID:


This will bring up the Select Email Variable dialog where you choose which event variable to use to look up the desired email..  Scroll through the entries in the Variable: ComboBox until you find the one with Offending User.  Press OK to save your choice:


This will insert the required text in the To: field to get the offending user's email during the processing of this event.  Complete the remaining fields as desired and press the Save button to complete the process of subscribing to the LCKEVENT event.


Notes

  • This mechanism of determining the email address of a specific Windows or Elliott user may be applied to other events, as long as there is an event variable that specifies either the Windows user or the Elliott user.
  • If, for any reason, Elliott cannot resolve the To: address, no email will be sent.

JEG
NWSMEVTV

Feedback and Knowledge Base