select ue
from com.soffid.iam.model.UserEntity ue
join ue.accounts as accounts
join accounts.account as acc
join acc.system as dispatcher
where acc.type='U' and dispatcher.name=:system and acc.name=:account and dispatcher.tenant.id = :tenantId
select usuari from com.soffid.iam.model.UserEntity usuari join usuari.attributes as dadaUsuari where dadaUsuari.dataType.name = 'NIF' and dadaUsuari.value = :nif and usuari.tenant.id = :tenantId
SELECT distinct usu
FROM com.soffid.iam.model.UserEntity usu join usu.attributes as dada
WHERE
dada.dataType.name = :dataType and
dada.value = :value and usu.tenant.id = :tenantId
select usuari from com.soffid.iam.model.UserEntity as usuari join usuari.primaryGroup as grup where grup.name=:primaryGroupName and usuari.tenant.id = :tenantId
select u.userName from com.soffid.iam.model.UserEntity as u where u.active='S'
Returns
java.util.List<
java.lang.String
>
findUsersByNationalID
select usuari from com.soffid.iam.model.UserEntity usuari join usuari.attributes as dadaUsuari where dadaUsuari.dataType.name = 'NIF' and dadaUsuari.value = :nif and usuari.tenant.id = :tenantId