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 Name | dict.name obtained in the second query |
| Object Type | objecttype.name obtained in the second query |
| Lock Information | dict.name obtained in the first query |
| Object Id | dict.eid obtained in the second query |