Index

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

• Description

DAO methods

• findLastDateBySystem

  select max(rac.startDate) as startDate
  from com.soffid.iam.model.AccessLogEntity rac where rac.system=:system and
  rac.tenant.id = :tenantId

  system

  java.lang.String

  Returns

  java.util.Date
• findAccessLogByAgentAndSessionIDAndEndDate

  select rac
  from com.soffid.iam.model.AccessLogEntity rac
  where rac.sessionId=:sessioId and rac.system = :system and (rac.endDate is null or rac.endDate=:date) and rac.server=:server and rac.tenant.id = :tenantId

  system

  java.lang.String

  sessioId

  java.lang.String

  date

  java.util.Date

  server

  com.soffid.iam.model.HostEntity

  Returns

  java.util.List< com.soffid.iam.model.AccessLogEntity >
• findAccessLogByAgentAndSessionIDAndEndDate2

  select rac
  from com.soffid.iam.model.AccessLogEntity rac
  where rac.sessionId=:sessioId and rac.system = :system and (rac.endDate is null or rac.endDate=:date) and rac.hostName=:hostName and rac.tenant.id = :tenantId

  system

  java.lang.String

  sessioId

  java.lang.String

  date

  java.util.Date

  hostName

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.AccessLogEntity >
• findAccessLogBySessionIDAndStartDate

  select rac
  from com.soffid.iam.model.AccessLogEntity rac
  where rac.sessionId=:sessioId and rac.system = :system and (rac.startDate=:date) and rac.server=:server and rac.tenant.id = :tenantId

  system

  java.lang.String

  sessioId

  java.lang.String

  date

  java.util.Date

  server

  com.soffid.iam.model.HostEntity

  Returns

  java.util.List< com.soffid.iam.model.AccessLogEntity >
• findAccessLogBySessionIDAndStartDate2

  select rac
  from com.soffid.iam.model.AccessLogEntity rac
  where rac.sessionId=:sessioId and rac.system = :system and (rac.startDate=:date) and rac.hostName=:hostName and rac.tenant.id = :tenantId

  system

  java.lang.String

  sessioId

  java.lang.String

  date

  java.util.Date

  hostName

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.AccessLogEntity >
• findByHostId

  from com.soffid.iam.model.AccessLogEntity rac where rac.server.id=:id or rac.client.id=:id and rac.tenant.id = :tenantId order by rac.startDate

  id

  java.lang.Long

  Returns

  java.util.List< com.soffid.iam.model.AccessLogEntity >
• findLastAccessLogByServerAndProtocol

  select registreAcces
  from com.soffid.iam.model.AccessLogEntity registreAcces
  where (:server is null or registreAcces.hostName like :server) and
  registreAcces.tenant.id = :tenantId and (:protocol is null or
  registreAcces.protocol.name = :protocol)
  order by registreAcces.startDate desc

  server

  java.lang.String

  protocol

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.AccessLogEntity >
• findLastAccessLogByUserName

  select registreAcces
  from com.soffid.iam.model.AccessLogEntity registreAcces
  left join registreAcces.user usuari
  where (:userName is null or usuari.userName like :userName) and
  (:protocol is null or
  registreAcces.protocol.name = :protocol) and
  registreAcces.tenant.id = :tenantId order by registreAcces.startDate

  userName

  java.lang.String

  protocol

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.AccessLogEntity >
• findAccessLogByStartDateAndUserName

  select registreAcces
  from com.soffid.iam.model.AccessLogEntity registreAcces
  left join registreAcces.user usuari
  where (:userName is null or usuari.userName like :userName) and
  (:startDate = :nullDate or registreAcces.startDate >= :startDate ) and
  registreAcces.tenant.id = :tenantId order by registreAcces.startDate

  nullDate

  java.util.Date

  startDate

  java.util.Date

  userName

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.AccessLogEntity >
• findAccessLogByStartDateAndUserNameAndProtocol

  select registreAcces
  from com.soffid.iam.model.AccessLogEntity registreAcces
  left join registreAcces.user usuari
  where (:userName is null or usuari.userName like :userName) and
  (:startDate = :nullDate or registreAcces.startDate >= :startDate ) and
  registreAcces.protocol.name= :protocol and
  registreAcces.tenant.id = :tenantId order by registreAcces.startDate desc

  nullDate

  java.util.Date

  startDate

  java.util.Date

  userName

  java.lang.String

  protocol

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.AccessLogEntity >
• findAccessLogByCriteria

  select registreAcces
  from com.soffid.iam.model.AccessLogEntity registreAcces
  left join registreAcces.user usuari
  where (:clientHostName is null or registreAcces.clientHostName like :clientHostName) and
  (:server is null or registreAcces.hostName like :server) and
  (:userName is null or usuari.userName like :userName) and registreAcces.tenant.id = :tenantId order by registreAcces.startDate
  

  clientHostName

  java.lang.String

  server

  java.lang.String

  userName

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.AccessLogEntity >
• findAccessLogByCriteria

  select registreAcces
  from com.soffid.iam.model.AccessLogEntity registreAcces
  left join registreAcces.user usuari
  where (:clientHostName is null or registreAcces.clientHostName like :clientHostName) and
  (:server is null or registreAcces.hostName like :server) and
  (:userName is null or usuari.userName like :userName) and
  (:maxDate = :nullDate or registreAcces.startDate < :maxDate ) and
  (:minDate = :nullDate or registreAcces.endDate > :minDate ) and registreAcces.tenant.id = :tenantId order by registreAcces.startDate

  nullDate

  java.util.Date

  maxDate

  java.util.Date

  minDate

  java.util.Date

  clientHostName

  java.lang.String

  server

  java.lang.String

  userName

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.AccessLogEntity >
• findAccessLogByCriteria2Dates

  select registreAcces
  from com.soffid.iam.model.AccessLogEntity registreAcces
  left join registreAcces.user usuari
  where (:clientHostName is null or registreAcces.clientHostName like :clientHostName) and
  (:server is null or registreAcces.hostName like :server) and
  (:userName is null or usuari.userName like :userName) and
  (:startDate = :nullDate or registreAcces.startDate >= :startDate ) and
  (:endDate = :nullDate or registreAcces.endDate <= :endDate ) and registreAcces.tenant.id = :tenantId order by registreAcces.startDate

  nullDate

  java.util.Date

  startDate

  java.util.Date

  endDate

  java.util.Date

  clientHostName

  java.lang.String

  server

  java.lang.String

  userName

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.AccessLogEntity >
• findAccessLogByCriteria2

  select registreAcces
  from com.soffid.iam.model.AccessLogEntity registreAcces
  left join registreAcces.user usuari
  where (:clientHostName is null or registreAcces.clientHostName like :clientHostName) and
  (:server is null or registreAcces.hostName like :server) and
  (:userName is null or usuari.userName like :userName) and
  (:startDate = :nullDate or registreAcces.endDate >= :startDate ) and
  (:endDate = :nullDate or registreAcces.startDate <= :endDate ) and registreAcces.tenant.id = :tenantId order by registreAcces.startDate

  nullDate

  java.util.Date

  startDate

  java.util.Date

  endDate

  java.util.Date

  clientHostName

  java.lang.String

  server

  java.lang.String

  userName

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.AccessLogEntity >
• findAccessLogByHost

  select registreAcces
  from com.soffid.iam.model.AccessLogEntity registreAcces
  where (:server is null or registreAcces.hostName like :server) and
  (:startDate = :nullDate or registreAcces.startDate >= :startDate ) and
  (:protocol is null or
  registreAcces.protocol.name = :protocol) and
  registreAcces.tenant.id = :tenantId order by registreAcces.startDate

  nullDate

  java.util.Date

  startDate

  java.util.Date

  server

  java.lang.String

  protocol

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.AccessLogEntity >
• findAccessLogByHostAndStartDateAndProtocol

  select registreAcces
  from com.soffid.iam.model.AccessLogEntity registreAcces
  where (:server is null or registreAcces.hostName like :server) and
  (:startDate = :nullDate or registreAcces.startDate >= :startDate ) and
  (:protocol is null or
  registreAcces.protocol.name = :protocol) and
  registreAcces.tenant.id = :tenantId order by registreAcces.startDate desc

  nullDate

  java.util.Date

  startDate

  java.util.Date

  server

  java.lang.String

  protocol

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.AccessLogEntity >

DAO Dependencies

• HostEntity
• ServiceEntity
• TenantEntity
• UserEntity

Managed value objects

• AccessLog

Service Dependencies

2/28/24