Skip to content

Instantly share code, notes, and snippets.

@jesuino

jesuino/NodeHits.sql

Created Feb 23, 2021
Embed
What would you like to do?
jBPM Process Node total hits
select
pil.externalId,
pil.processId,
nil.nodeid,
nil.nodetype,
nil.nodename,
count(nil.nodeid) as total_hits
from
NodeInstanceLog nil
inner join
ProcessInstanceLog pil on pil.processInstanceId = nil.processInstanceId
where
nil.type = 1
group by
pil.externalId,
nil.nodeid,
nil.nodename
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment