select account.name from com.soffid.iam.model.AccountEntity as account where account.system.name=:systemName and (account.status is null or account.status = 'a' or account.status='d')
select acc
from com.soffid.iam.model.AccountEntity acc
join acc.users as users join users.user as user where user.userName=:user and user.tenant.id=:tenantId and acc.system.passwordDomain.name=:domain and acc.type='U'
select acc
from com.soffid.iam.model.AccountEntity acc
left join acc.users as users
left join users.user as user
left join acc.system as dispatcher
where acc.type='U' and user.userName = :user and dispatcher.name = :dispatcher and dispatcher.tenant.id = :tenantId order by user.userName, acc.name
select acc from com.soffid.iam.model.AccountEntity acc where acc.name = :name and acc.system.name = :system and acc.system.tenant.id = :tenantId order by acc.name
