The Lock is a table (meta_md_lock) in the System Monitor module of iTopia. This view only works with tables that are set up as "transaction header" tables (that is, tables that allow maintenance). The Lock view is used as part of the application-level locking prcedure, which is a step in the UMS administration process.

The Lock view is to perform the following operations:

• Query the records in the lock table.
• Delete the records in lock table.

This view serves as a means of determining the record that is being locked along with the user name of the user responsible for the lock, and the view associated with the lock. The view also displays all of the locks existing for all users.

• To examine only the records that your user id is currently locking, click the Profile menu option (found in the header section on any iTopia view or on any menu page) and select the 'My Lock' view from the list of Related resources.

The Lock table is automatically populated by the system whenever a user launches a transactional header table and then adds a new record through the Create action, or goes to the Details page of an existing record.

• Records are automatically deleted from this table when the user that is viewing a record in a transactional-type table clicks the Submit action, or when the user logs out of iTopia, in which case all locks held by the browser session are removed.

• If the browser fails or if the user closes the window without logging out, the application-level locks are removed once the timeout for the application is reached. Locks are cleaned up as part of the application un-registration, and thus will time out automatically as part of the application timeout. An application may time out before its session; however, when the session times out, all of its applications are un-registered.

The columns in Lock view cannot be modified, however the records can be deleted. The following fields are available on the Lock view and are based on the order in which they appear in the grid on the search page:

• Lock ID - displays the unique identifier for a given lock record. The corresponding transaction table record will have a lock ID column that points to this value.

• User Name - displays the User Name associated with the user ID that initially opened the transactional record.

• View Name - displays the name of the view that contains the locked record.

• Session ID - displays the unique identifier for the session ID.

• Date/Time Created - displays the date and time the user first created the lock record.

• Last Access Time - displays the last date and time the user accessed a given record.

For information on the functionality of each button on the Lock Search Criteria Results/Grid page, click here.

Lock Details Page

The following list defines every field on the Details page:

• User Name - displays the User Name associated with the user ID that initially opened the transactional record.

• Session ID - displays the unique identifier for the session ID.

• Date/Time Created - displays the date and time the user first created the lock record.

• Last Access Time - displays the last date and time the user accessed a given record.

There are four Related views:

• Session
• Application
• Application - Attribute
• Attribute

For information on the functionality of each button on the Lock Search Criteria Details page, click here.