Entity DAO com.soffid.iam.am.model.PasswordPolicyEntityDao [Entity]
Description
DAO methods
findByAccount
select pp from
com.soffid.iam.base.model.AccountEntity as acc, com.soffid.iam.am.model.PasswordPolicyEntity as pp, com.soffid.iam.iga.model.SystemEntity as sys where acc.id=:id and acc.system.id = sys.id and acc.passwordPolicy.id = pp.userType.id and sys.passwordDomain.id = pp.passwordDomain.id
select pol from
com.soffid.iam.am.model.PasswordPolicyEntity pol
left join pol.passwordDomain domini
left join pol.userType tus
where domini.name=:passwordDomain and
domini.tenant.id = :tenantId and tus.name=:userType
select pol from
com.soffid.iam.am.model.PasswordPolicyEntity pol
left join pol.passwordDomain con
where (:passwordDomain is null or con.name=:passwordDomain) and
con.tenant.id = :tenantId order by con.name