select
new org.jbpm.kie.services.impl.model.ProcessInstanceDesc(
log.processInstanceId,
log.processId,
log.processName,
log.processVersion,
log.status,
log.externalId,
log.start,
log.identity
)
from
ProcessInstanceLog log
ORDER BY
log.processId, log.start
select
new org.jbpm.kie.services.impl.model.ProcessInstanceDesc(
log.processInstanceId,
log.processId,
log.processName,
log.processVersion,
log.status,
log.externalId,
log.start,
log.identity
)
from
ProcessInstanceLog log
where
log.status in (:states)
select
new org.jbpm.kie.services.impl.model.ProcessInstanceDesc(
log.processInstanceId,
log.processId,
log.processName,
log.processVersion,
log.status,
log.externalId,
log.start,
log.identity
)
from
ProcessInstanceLog log
where
log.status in (:states) and log.identity = :initiator
select
new org.jbpm.kie.services.impl.model.ProcessInstanceDesc(
log.processInstanceId,
log.processId,
log.processName,
log.processVersion,
log.status,
log.externalId,
log.start,
log.identity
)
from
ProcessInstanceLog log
where
log.externalId=:externalId
and log.status in (:states)
select
new org.jbpm.kie.services.impl.model.ProcessInstanceDesc(
log.processInstanceId,
log.processId,
log.processName,
log.processVersion,
log.status,
log.externalId,
log.start,
log.identity
)
from
ProcessInstanceLog log
where
log.processId =:processDefId
select
new org.jbpm.kie.services.impl.model.ProcessInstanceDesc(
log.processInstanceId,
log.processId,
log.processName,
log.processVersion,
log.status,
log.externalId,
log.start,
log.identity
)
from
ProcessInstanceLog log
where
log.processInstanceId =:processId
select
new org.jbpm.kie.services.impl.model.ProcessInstanceDesc(
log.processInstanceId,
log.processId,
log.processName,
log.processVersion,
log.status,
log.externalId,
log.start,
log.identity
)
from
ProcessInstanceLog log
where
log.status in (:states) and log.processId like :processId
select
new org.jbpm.kie.services.impl.model.ProcessInstanceDesc(
log.processInstanceId,
log.processId,
log.processName,
log.processVersion,
log.status,
log.externalId,
log.start,
log.identity
)
from
ProcessInstanceLog log
where
log.status in (:states) and log.processId like :processId and log.identity = :initiator
select
new org.jbpm.kie.services.impl.model.ProcessInstanceDesc(
log.processInstanceId,
log.processId,
log.processName,
log.processVersion,
log.status,
log.externalId,
log.start,
log.identity
)
from
ProcessInstanceLog log
where
log.status in (:states) and log.processName like :processName
select
new org.jbpm.kie.services.impl.model.ProcessInstanceDesc(
log.processInstanceId,
log.processId,
log.processName,
log.processVersion,
log.status,
log.externalId,
log.start,
log.identity
)
from
ProcessInstanceLog log
where
log.status in (:states) and log.processName like :processName and log.identity = :initiator
select
new org.jbpm.kie.services.impl.model.NodeInstanceDesc(
log.nodeInstanceId,
log.nodeId,
log.nodeName,
log.nodeType,
log.externalId,
log.processInstanceId,
log.date,
log.connection,
log.type
)
from
NodeInstanceLog log
where
log.processInstanceId=:processId AND log.externalId=:externalId AND log.type =:type
ORDER BY
log.date DESC, log.id DESC
select
new org.jbpm.kie.services.impl.model.NodeInstanceDesc(
log.nodeInstanceId,
log.nodeId,
log.nodeName,
log.nodeType,
log.externalId,
log.processInstanceId,
log.date,
log.connection,
log.type
)
from
NodeInstanceLog log
where
log.processInstanceId=:processId AND log.externalId=:externalId
ORDER BY
log.date DESC, log.id DESC
select
new org.jbpm.kie.services.impl.model.NodeInstanceDesc(
log.nodeInstanceId,
log.nodeId,
log.nodeName,
log.nodeType,
log.externalId,
log.processInstanceId,
log.date,
log.connection,
log.type
)
from
NodeInstanceLog log
where
log.nodeInstanceId in ( select nil.nodeInstanceId from NodeInstanceLog nil where nil.processInstanceId=:processId AND nil.externalId=:externalId
GROUP BY nil.nodeInstanceId
HAVING sum(nil.type) = 0)
and log.type = 0
and log.processInstanceId=:processId
order by
log.id ASC
select
new org.jbpm.kie.services.impl.model.NodeInstanceDesc(
log.nodeInstanceId,
log.nodeId,
log.nodeName,
log.nodeType,
log.externalId,
log.processInstanceId,
log.date,
log.connection,
log.type
)
from
NodeInstanceLog log
where
log.nodeInstanceId in (select nodeInstanceId from NodeInstanceLog nid where nid.processInstanceId=:processId AND nid.externalId=:externalId AND nid.type = 1
GROUP BY nid.nodeInstanceId
HAVING sum(nid.type) >= 1)
and log.type = 1
and log.processInstanceId=:processId
ORDER BY
log.nodeInstanceId, log.id ASC
select
new org.jbpm.kie.services.impl.model.VariableStateDesc(
log.variableId,
log.variableInstanceId,
log.oldValue,
log.value,
log.externalId,
log.processInstanceId,
log.date
)
from
VariableInstanceLog log
where
log.processInstanceId =:processInstanceId AND log.id in (select max(vss.id) FROM VariableInstanceLog vss WHERE vss.processInstanceId =:processInstanceId group by vss.variableId ) order by log.id
select
new org.jbpm.kie.services.impl.model.VariableStateDesc(
log.variableId,
log.variableInstanceId,
log.oldValue,
log.value,
log.externalId,
log.processInstanceId,
log.date
)
from
VariableInstanceLog log
where
log.processInstanceId =:processInstanceId AND log.variableId =:variableId
order by
log.id DESC