@Query("SELECT r.id from Role r where (r.roleName = CONCAT('Master+', ?1) " + "OR r.roleName like CONCAT('ModifyNamespace+', ?1, '+%') " + "OR r.roleName like CONCAT('ReleaseNamespace+', ?1, '+%'))") List<Long> findRoleIdsByAppId(String appId);
@Query("SELECT r.id from Role r where (r.roleName = CONCAT('ModifyNamespace+', ?1, '+', ?2) " + "OR r.roleName = CONCAT('ReleaseNamespace+', ?1, '+', ?2))") List<Long> findRoleIdsByAppIdAndNamespace(String appId, String namespaceName);
@Query("SELECT p.id from Permission p where p.targetId = ?1 or p.targetId like CONCAT(?1, '+%')") List<Long> findPermissionIdsByAppId(String appId);