Documentation Center

List of Locked Objects

The following two queries list all the objects locked under the project object selected by the user.

SELECT dict.name, useracct.xy_uid, useracct.desktop_id 
FROM useracct, dict 
WHERE useracct.desktop_id = dict.eid; 
	 
SELECT dict.name, dict.eid, dict.owner_lock, dict.export_lock, objecttype.name 
FROM parent_list, dict, objecttype 
WHERE parent_list.cfg = [BlobId of the object] AND
      parent_list.child = dict.eid AND
      dict.user_type <> 20 AND
      (dict.owner_lock <> 0 OR dict.export_lock <> 0) AND
      dict.abs_number = objecttype.abstype 
ORDER BY dict.name; 
	 

The dict.export_lock and ict.owner_lock values are equal to useracct.xy_uid. If the object is locked, then the value for dict.export_lock or dict.owner_lock is greater than zero.

Example: Project Lock Report

Column label:Contains the following data:
Object Namedict.name obtained in the second query
Object Type objecttype.name obtained in the second query
Lock Informationdict.name obtained in the first query
Object Iddict.eid obtained in the second query