Group Lock

[MiWin-IT]

Hi all,

Is there a way to retrieve all packages on which a specific group lock has been applied ?
I found the GUID of my group lock in t_seclocks via a search, but now I have to find all the packages locked by this one ; unfortunately I don't find the right table to search for...
Any help would be appreciated.

Many thanks.

Michel.

[Geert Bellekens]

There is no GUID for a Lock.

t_seclocks contains the ID of the user/group, and the GUID of the locked element. This could be a element (t_object) a package (t_package) or a diagram (t_diagram)

Geert

[MiWin-IT]

Hi Geert,

Many thanks for your answer.
Indeed my wording was not correct, the ID I retreived is the one of the Goup I'm searching for.
I did some tries and finally got the right query, here it is:

select * from t_object
where Stereotype = 'myStereotype'   <= used to narrow the search
and ea_guid in 
(select EntityID from t_seclocks
where GroupID = '{5CD33F3E-022C-4ccc-85BE-557AB3F9BA74}' <= GUID of the Group
and EntityType = 'Element')

Michel