Index

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

• Description

DAO methods

• countTasksByServerAndSystem

  select s.name, count(distinct tlo.task.id) from
  com.soffid.iam.model.TaskLogEntity tlo left outer join tlo.system as s
  where tlo.task.tenant.id = :tenantId and tlo.completed='S' and tlo.task.server=:server and
  (tlo.task.systemName is null or tlo.task.systemName = s.name) group by s.name
  order by s.name

  server

  java.lang.String

  Returns

  java.util.Collection< java.lang.Object[] >
• countTasksByServerAndSystem

  select s.name, count(distinct tlo.task.id) from
  com.soffid.iam.model.TaskLogEntity tlo left outer join tlo.system as s
  where tlo.task.tenant.id = :tenantId and tlo.completed='S' and tlo.task.server=:server and tlo.task.serverInstance=:serverInstance and
  (tlo.task.systemName is null or tlo.task.systemName = s.name) group by s.name
  order by s.name

  server

  java.lang.String

  serverInstance

  java.lang.String

  Returns

  java.util.Collection< java.lang.Object[] >
• countTasksBySystem

  select s.name, count(distinct tlo.task.id) from
  com.soffid.iam.model.TaskLogEntity tlo left outer join tlo.system as s
  where tlo.task.tenant.id = :tenantId and tlo.completed='S'
  group by s.name
  order by s.name

  Returns

  java.util.Collection< java.lang.Object[] >
• findAllHavingTasqueByAgentAndServer

  select tlog from com.soffid.iam.model.TaskLogEntity tlog
  left join tlog.system system
  left join tlog.task task
  where system.name=:system and
  (:status is null or tlog.completed=:status) and (
  (:server is not null and task.server=:server) or
  (:server is null and task.server is null)
  ) order by task.id, system.name

  server

  java.lang.String

  system

  java.lang.String

  status

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.TaskLogEntity >
• findAllHavingTasqueByServer

  select tlog from com.soffid.iam.model.TaskLogEntity tlog
  left join tlog.task tasca
  where
  (:server is not null and tasca.server=:server)
  or (:server is null and tasca.server is null)
  order by tlog.task.id, tlog.system.name

  server

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.TaskLogEntity >
• findAllHavingTasqueByServerAndServerInstance

  select tlog from com.soffid.iam.model.TaskLogEntity tlog
  left join tlog.task tasca
  where
  (:server is not null and tasca.server=:server) or (:server is null and tasca.server is null) and
  (:serverInstance is not null and tasca.serverInstance=:serverInstance) or (:serverInstance is null and tasca.serverInstance is null)
  order by tlog.task.id, tlog.system.name

  server

  java.lang.String

  serverInstance

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.TaskLogEntity >
• findByTaskID

  from com.soffid.iam.model.TaskLogEntity tlog
  where tlog.task.id=:taskId

  taskId

  java.lang.Long

  Returns

  java.util.List< com.soffid.iam.model.TaskLogEntity >
• findByServerAndSystem

  select tlog from com.soffid.iam.model.TaskLogEntity tlog where tlog.system.name=:system and (tlog.task.server=:server and :server is not null or tlog.task.server is null and :server is null) order by tlog.task.id, tlog.system.name

  server

  java.lang.String

  system

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.TaskLogEntity >
• findByServerAndSystem

  select tlog from com.soffid.iam.model.TaskLogEntity tlog where tlog.system.name=:system and (tlog.task.server=:server and :server is not null or tlog.task.server is null and :server is null) and (tlog.task.serverInstance=:serverInstance and :serverInstance is not null or tlog.task.serverInstance is null and :serverInstance is null)order by tlog.task.id, tlog.system.name

  server

  java.lang.String

  serverInstance

  java.lang.String

  system

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.TaskLogEntity >
• findBySystem

  select tlog from com.soffid.iam.model.TaskLogEntity tlog where tlog.system.name=:system order by tlog.task.id, tlog.system.name

  system

  java.lang.String

  Returns

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

DAO Dependencies

• SystemEntity
• TaskEntity

Managed value objects

Service Dependencies

2/28/24