select rolEntity
from com.soffid.iam.iga.model.RoleEntity rolEntity
where rolEntity.externalId = :externalId and
rolEntity.system.name = :system and rolEntity.system.tenant.id = :tenantId and (rolEntity.deleted is null or rolEntity.deleted is false)
select rolEntity
from com.soffid.iam.iga.model.RoleEntity rolEntity
where rolEntity.name = :roleName and
rolEntity.system.name = :system and (rolEntity.deleted is null or rolEntity.deleted is false) and rolEntity.system.tenant.id = :tenantId and rolEntity.deletedOn is null
select rolEntity
from com.soffid.iam.iga.model.RoleEntity rolEntity
where rolEntity.name = :roleName and
rolEntity.system.name = :system and (rolEntity.deleted is null or rolEntity.deleted is false)
select rolEntity
from com.soffid.iam.iga.model.RoleEntity rolEntity
where
rolEntity.informationSystem.name = :informationSystem and
rolEntity.name = :roleName and rolEntity.system.tenant.id = :tenantId and
(rolEntity.deleted is null or rolEntity.deleted is false) and rolEntity.system.name = :system
select u from com.soffid.iam.iga.model.RoleEntity as u where (u.domainType = 'APLICACIONS' or u.domainType = 'APPLICATIONS') and u.id in (select e.role.id from com.soffid.iam.base.model.AuthorizationEntity e) and (u.deleted is null or u.deleted is false) and u.system.tenant.id=:tenantId
select distinct u from com.soffid.iam.iga.model.RoleEntity as u where (u.domainType = 'GRUPS' or u.domainType='GRUPS_USUARI' or u.domainType='GROUPS' or u.domainType='MEMBERSHIPS') and u.id in (select e.role.id from com.soffid.iam.base.model.AuthorizationEntity e) and (u.deleted is null or u.deleted is false) and u.system.tenant.id=:tenantId
select role
from com.soffid.iam.iga.model.RoleEntity role
where role.informationSystem.name = :informationSystem and role.informationSystem.tenant.id = :tenantId and (role.deleted is null or role.deleted is false)
order by role.name, role.system.name
select rol from com.soffid.iam.iga.model.RoleEntity rol join rol.applicationDomain domini left join domini.informationSystem aplicacio where domini.name = :domainName and (rol.deleted is null or rol.deleted is false) and ((:informationSystem is null and aplicacio is null) or (aplicacio.name = :informationSystem)) and aplicacio.tenant.id = :tenantId
select u.name from com.soffid.iam.iga.model.RoleEntity as u join u.system as s where s.name = :system and (u.deleted is null or u.deleted is false)
system
java.lang.String
Returns
java.util.List<
java.lang.String
>
findRolesByUserName
select rol
from com.soffid.iam.base.model.UserEntity usu
join usu.accounts as accounts
join accounts.account as account with account.type='U'
join account.roles as roles
join roles.role as rol
where usu.userName = :userName and usu.tenant.id = :tenantId and roles.enabled is true and (rol.deleted is null or rol.deleted is false)
select role
from com.soffid.iam.base.model.UserEntity user
join user.accounts as accounts
join accounts.account as account with account.type='U'
join account.roles as roles
join roles.role as role
join role.informationSystem as informationSystem
where user.userName = :userName and informationSystem.name = :informationSystem and (role.deleted is null or role.deleted is false)
and user.tenant.id = :tenantId
