select distinct aplicacio
from com.soffid.iam.base.model.UserEntity as usuari
join usuari.accounts as accounts
join accounts.account as account
join account.roles as roles
join roles.role as rol
join rol.informationSystem as aplicacio
where usuari.userName = :userName
and aplicacio.tenant.id = :tenantId
select distinct aplicacio
from com.soffid.iam.base.model.UserEntity as usuari
join usuari.accounts as accounts
join accounts.account as account
join account.roles as roles
join roles.role as rol
join rol.informationSystem as aplicacio with aplicacio.bpmEnabled='S'
where usuari.userName = :userName
and aplicacio.tenant.id = :tenantId