Index

Entity DAO com.soffid.iam.model.AuditEntityDao [Entity]

• Description

DAO methods

• findById

  id

  java.lang.Long

  Returns

  com.soffid.iam.model.AuditEntity
• findByIndex

  select a from com.soffid.iam.model.AuditEntity as a where searchIndex=:searchIndex and tenant.id=:tenantId order by date asc

  searchIndex

  java.lang.String

  Returns

  java.util.Collection< com.soffid.iam.model.AuditEntity >
• findAuditByCriteria1

  select audit from com.soffid.iam.model.AuditEntity audit
  left join audit.accountAssoc accountAssoc
  where (:user is null or audit.user like :user) and
  (:object is null or audit.object like :object) and
  (:author is null or accountAssoc.name like :author) and
  (:action is null or audit.action=:action) and
  audit.tenant.id = :tenantId
  order by audit.date asc

  author

  java.lang.String

  object

  java.lang.String

  user

  java.lang.String

  action

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.AuditEntity >
• findAuditByCriteria2

  select audit from com.soffid.iam.model.AuditEntity audit
  left join audit.accountAssoc accountAssoc
  where (:user is null or audit.user like :user) and
  (:object is null or audit.object like :object) and
  (:author is null or accountAssoc.name like :author) and
  (:action is null or audit.action=:action)
  and (:column is null or
  (:column is not null and
  (
  ((:column='domini' or :column='domain') and audit.domain like :value)
  or ((:column='valorDomini' or :column='domainValue') and audit.domainValue like :value)
  or ((:column='parametreConfiguracio' or :column='configurationParameter') and audit.configurationParameter like :value)
  or ((:column='bbdd' or :column='database') and audit.db like :value)
  or ((:column='impressora' or :column='printer') and audit.printer like :value)
  or ((:column='aplicacio' or :column='informatinSystem') and audit.informationSystem like :value)
  or ((:column='dominiCorreu' or :column='mailDomain') and audit.mailDomain like :value)
  or ((:column='llistaCorreu' or :column='mailList') and audit.mailList like :value)
  or ((:column='fitxer' or :column='file') and audit.fileId like :value)
  or ((:column='xarxa' or :column='network') and audit.network like :value)
  or ((:column='rol' or :column='role') and audit.role like :value)
  or ((:column='maquina' or :column='host') and audit.host like :value)
  or ((:column='autoritzacio' or :column='authorization') and audit.authorization like :value)
  or ((:column='grup' or :column='group') and audit.group is not null and audit.group.name like :value)
  or (:column='userType' and audit.userType like :value)
  or (:column='passwordDomain' and audit.passwordDomain like :value)
  or (:column='userDomain' and audit.userDomain like :value)
  )
  )
  ) and audit.tenant.id = :tenantId
  order by audit.date asc

  author

  java.lang.String

  object

  java.lang.String

  user

  java.lang.String

  column

  java.lang.String

  value

  java.lang.String

  action

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.AuditEntity >
• findAuditByCriteria3

  select audit from com.soffid.iam.model.AuditEntity audit
  left join audit.accountAssoc accountAssoc
  where (:user is null or audit.user like :user) and
  (:until = :nullDate or audit.date < :until ) and
  (:since = :nullDate or audit.date > :since ) and
  (:object is null or audit.object like :object) and
  (:author is null or accountAssoc.name like :author) and
  (:action is null or audit.action=:action) and
  audit.tenant.id = :tenantId
  order by audit.date asc

  nullDate

  java.util.Date

  until

  java.util.Date

  since

  java.util.Date

  author

  java.lang.String

  object

  java.lang.String

  user

  java.lang.String

  action

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.AuditEntity >
• findAuditByCriteria4

  select audit from com.soffid.iam.model.AuditEntity audit
  left join audit.accountAssoc accountAssoc
  where (:user is null or audit.user like :user) and
  (:until = :nullDate or audit.date < :until ) and
  (:since = :nullDate or audit.date > :since ) and
  (:object is null or audit.object like :object) and
  (:author is null or accountAssoc.name like :author) and
  (:action is null or audit.action=:action) and
  (:column is null or
  (:column is not null and
  (
  ((:column='domini' or :column='domain') and audit.domain like :value)
  or ((:column='valorDomini' or :column='domainValue') and audit.domainValue like :value)
  or ((:column='parametreConfiguracio' or :column='configurationParameter') and audit.configurationParameter like :value)
  or ((:column='bbdd' or :column='database') and audit.db like :value)
  or ((:column='impressora' or :column='printer') and audit.printer like :value)
  or ((:column='aplicacio' or :column='informatinSystem') and audit.informationSystem like :value)
  or ((:column='dominiCorreu' or :column='mailDomain') and audit.mailDomain like :value)
  or ((:column='llistaCorreu' or :column='mailList') and audit.mailList like :value)
  or ((:column='fitxer' or :column='file') and audit.fileId like :value)
  or ((:column='xarxa' or :column='network') and audit.network like :value)
  or ((:column='rol' or :column='role') and audit.role like :value)
  or ((:column='maquina' or :column='host') and audit.host like :value)
  or ((:column='autoritzacio' or :column='authorization') and audit.authorization like :value)
  or ((:column='grup' or :column='group') and audit.group is not null and audit.group.name like :value)
  or (:column='userType' and audit.userType like :value)
  or (:column='passwordDomain' and audit.passwordDomain like :value)
  or (:column='userDomain' and audit.userDomain like :value)
  )
  )
  ) and
  audit.tenant.id = :tenantId
  order by audit.date asc

  nullDate

  java.util.Date

  until

  java.util.Date

  since

  java.util.Date

  author

  java.lang.String

  object

  java.lang.String

  user

  java.lang.String

  column

  java.lang.String

  value

  java.lang.String

  action

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.AuditEntity >
• unlinkAccounts

  Unlinks audit logs from account that is going to be removed

  account

  com.soffid.iam.model.AccountEntity

  Returns

  void

DAO Dependencies

• AccountEntity
• InformationSystemEntity
• SystemEntity
• EmailDomainEntity
• GroupEntity
• PrinterEntity
• EmailListEntity
• HostEntity
• RoleEntity
• TenantEntity
• UserEntity
• NetworkEntity

Managed value objects

• Audit

Service Dependencies

• PasswordService

2/28/24