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. The Lock view is used as part of the application-level locking procedure, 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.

• 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 from both the Search Results or Details page. 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:

• User Name - displays the name of the user who has locked the record.

• Full Name - displays the full name of the user who has locked the record.

• 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.

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

• Go - this is a link that, when clicked, opens the view containing the locked record. Hovering over this link displays 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

There are two sections on the Details page. The following list defines every field in each section:

In the General section:

• User Name - displays the name of the user who has locked the record.

• Full Name - displays the full name of the user who has locked the record.

• 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.

• View Name - displays the name of the view in 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.

In the Transaction section:

• Go - this is a link that, when clicked, opens the view containing the locked record.

• A visual representation of the locked record displays below the Go link.

The Related views include:

• Session
• Application
• Application - Attribute
• Attribute
• Application Server Instance

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