Třídová akce

Kód:

3

Tělo:

SELECT C.ID, C.Code, C.Name, C.Data, C.Ranking
FROM RoleAppProfiles A
JOIN RoleAppProfiles2 B ON B.Parent_ID = A.ID
JOIN RoleAppLayouts C ON C.ID = B.Layout_ID
WHERE A.App_ID = :AppID
AND EXISTS 
  ( SELECT D.ID
	FROM RoleAppProfileRoles D
	JOIN SecurityUserRoleLinks SURL ON SURL.Role_ID = D.Role_ID
	WHERE D.Parent_ID = A.ID AND SURL.User_ID = :UserID
  )

Generated by ABRA Software a.s. 27.10.2021 16:34:11