Record Locks

It is configurable that system administrator can decide whether to lock a record or not while someone is editing the record. If the system is set to lock the record and use table lock, every time, when user is editing a record, a record is added in the record locks table. When user finished editing, either via update or cancel, or session timeout, the lock is released by delete the record mark form record locks table.

In rare situation, if the application server is terminated abortly, the record will stay in the record locks table.

This function is used to manage those record locks, either delete unused one, or force someone to unlock it.

Click the "Record Locks" in the left navigation menu under Administration, a new "Record Locks" Tab folder will created in the right panel. There are 2 sub-Tab folders, Search Manage Locked Records and Search result Manage Locked Records.

• Search Locked Record
• Search Result Locked Record
• Update Locked Record

a) Search Locked Record

Search Criteria

Table Name The table name that record is locked Record Id The locked record Id Lock Time When the lock occurred Session Id The session Id of the user who locks the record

Table Name	The table name that record is locked.
Record Id	The locked record Id.
Lock Time	When the lock occurred.
Session Id	The session Id of the user who locks the record.
AND and OR	Select AND radio box if you want those criteria add together. Select OR radio box if you want to get the result of either criteria meet

Functional buttons

1. Find:
   click Find button to search.
2. Clear:
   click Clear button to clear all the criteria.
3. Complex Search:
   switch to Complex search mode.

b) Search Result Locked Record

The top part is the table, shows the list of the admin history that meet the search criteria. The bottom part is the details of the selected entry.

c) Update Locked Record

Double Click the selected record in the table to modify this entry. A new Tab folder "Update/Delete Manage Locked Records" will be added, as show below:

Functional buttons

1. Reset:
   reset the data to its initial value, discard all the changes.
2. Cancel:
   Cancel this change and switch back to "Search result Manage Locked Records" Tab.
3. Delete:
   Delete this entry; then switch back to "Search result Manage Locked Records" Tab.

There is no updated on the Record Locks function.
There is no create new on the Record Locks function either.