Skip to content

Instantly share code, notes, and snippets.

@jesuino

jesuino/NodeHits.sql

Created February 23, 2021 16:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jesuino/16c74bab0d807b30bd858a7e87d46233 to your computer and use it in GitHub Desktop.
Save jesuino/16c74bab0d807b30bd858a7e87d46233 to your computer and use it in GitHub Desktop.
Download ZIP
jBPM Process Node total hits
Raw
NodeHits.sql
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