select pr.pname, pr.pkey, sp.PERMISSION_KEY, sp.perm_parameter from project pr
LEFT JOIN nodeassociation n ON n.SOURCE_NODE_ID = pr.id and n.SINK_NODE_ENTITY = 'PermissionScheme'
JOIN permissionscheme p on n.SINK_NODE_ID = p.id
jOIN schemepermissions sp on sp.SCHEME = p.ID
where perm_type in ('user', 'group')
HI.
Hello ,
I want list of all projects of jira with the individual added in particular project.
e.g
project name| key|permission|name of user or group|
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI . You can use this SQL query
SELECT PS.name AS PermissionSchemeName,SP.perm_parameter AS GroupName, SP.permission_key AS Permission
FROM schemepermissions SP
INNER JOIN permissionscheme PS ON SP.scheme = PS.id
where perm_type = 'user'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
any details? My result *(
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.