Entity DAO com.soffid.iam.model.TaskLogEntityDao [Entity]
Description
DAO methods
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
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
select tlog from com.soffid.iam.model.TaskLogEntity tlog where tlog.system.name=:system and exists ( select 1 from com.soffid.iam.model.TaskEntity tasca where tasca.id = tlog.task.id and ( (: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