Blocking of concurrent access to the same document or record

From the release 2015.05 QualiWare implements a locking mechanism that prevents two users to work simultaneously on the same document or recording. This mechanism works in a slightly different way of documents or forms inserted in the document management, and records such non conformity, Reports/Complaints, etc.

Document management

Opening the document management form on a complete or filtered category and positioning itself on a document, the lock is activated when you make a transaction that can edit metadata, or the document itself (for esxample by clicking on the “Write” button or “modify data”). Once activated the lock by a user, if another user (or the same user from another form) try to perform the same operation on the same document will receive a message “Document in use” with an indication of ‘ user who has blocked it.

The block remains as long as the user who has acquired does not move to a different document or does not come out from the form.

In case of abnormal output from the card (for example in the case of the Web version for closing without using the “Exit” button) the lock is held for 3 minutes, after which expire and can be accessed again in editing by another user.

records management

The loading of a recording within its management form is automatically set the recording block itself. Another user who logs on to the same recording (or the same user who logs on to a different form) will receive the message “Document in use” with the indication that the user has locked.

As with document management, the block continues until the user who has acquired does not move to a different record or does not come out from the form.

And also in this case, if the form is closed abnormally (for example in the case of the Web version for closing without using the “Exit” button) the lock is held for 3 minutes, after which expire and can be accessed again in the change from part of another user.

Block management at the database level

The block of a document or record is written on the LOCKS table with details of the user code, a unique identifier of the card and the date of last update, contained in LAST_UPDATE field. When a form issues a block is emptied “LAST_UPDATE” field. If the form is closed abnormally, the field is not updated and the lock is considered active for three minutes by the control system.