Ask a Question

How to find out the number of active Human Tasks currently?

0 votes
889 views
in Process Server by (16.3k points)
edited by 
select 'ACTIVETASKS' as name, count(distinct task_id) as value from LSW_TASK where status=12  and activity_task_type = 1 and execution_status = 3

1 Answer

0 votes
by (16.3k points)
edited by 
select 'ACTIVETASKS' as name, count(distinct task_id) as value from LSW_TASK where status=12  and activity_task_type = 1 and execution_status = 3

Related questions

0 votes
1 answer 1.4k views
How to find out how many and which users are online on the Portal at a given time?
asked Oct 7, 2017 in Process Server by Anil Singh (16.3k points)
0 votes
1 answer 1.5k views
How to detect the step in case of accidental infinite loop ?
asked May 17, 2016 in Process Server by anonymous
0 votes
0 answers 238 views
How can we find out the bpd id/artifact id for a event gateway etc for migration purposes?
asked May 17, 2016 in BPD by anonymous
0 votes
0 answers 322 views
How to enhance any Out of Box Control with a fire boundary event trigger?
asked May 16, 2016 in Coach Views by BPM Tips Admin (21.6k points)
0 votes
1 answer 1.0k views
How to kill active tokens of completed instances in process inspector of IBM BPM 8.5+?
asked Oct 18, 2019 by user-BPM (120 points)
0 votes
0 answers 2.7k views
How to get the control name of a Button control in a coach view
asked Jan 12, 2022 in Coach Views by Ganesh (270 points)

635 questions

495 answers

98 comments

3.0k users

Join BPM Community Discord Channel

Welcome to BPM Tips Q&A, Community wiki/forum where you can ask questions and receive answers from other IBM BPM experts and members of the community. Users with 2000 points will automatically be promoted to expert level.
Created by Dosvak LLC
Our Youtube Channel

Categories

Most popular tags

#ibmbpm bpm baw ibm #coachviews workflow #integrations ecm bpm-ibm toolkits portal java #baw validationerror webdesigner processdesigner - coachview stored validation database procedure team rest migration #text-rich #client-side #texteditor #heritage #heritagehumanservice #hss bpd-integrations bpmservices ibmbpm notreachanble humanservices @username #ibmbaw#ibmbpm#baw#table #error migration- #bpm #eventhandler #bpmadmin #function #button debugger pet filenet cometd #production #processcenter #processserver log4j breadcrumbs careers jobs html- css- crumb- io pdf hierarchy inspector authentication cmis bread responsive section dependency db2 enterprise package tab dashboard artifact file page query email views start filter center ui playback standard rules bal decision js search service bpd variables integrations coaches services coach process 5
Powered by Dosvak LLC
...