Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

JS to check if a workflow is running

maurizio_coro
Level 3
Level 3

Hi!

Is there any way to check from a JSSP page (inside AC) if a specific WF is actually running?

I can't use @state because it's always in "started"

Thanks a lot.

Maurizio

1 Accepted Solution
sagil23995776
Correct answer by
Level 3
Level 3

Hi,
If the workflow is always 'started' because there is a signal or scheduler activity

then you can just query how many activities (except for signals/schedulers) did not finish running - meaning the workflow is currently running.

You can do something like:

instance.vars.workflowId = <your workflow Id>

instance.vars.running=sqlGetDouble("select count(*) from xtkworkflowtask where iworkflowid= " + instance.vars.workflowId + " and tscompletion is null and sactivity <>'schedule' and sactivity <>'signal' ");

if instance.vars.running > 0 then your workflow is currently running.

Hope it helps,

Sagi

View solution in original post

3 Replies
sagil23995776
Correct answer by
Level 3
Level 3

Hi,
If the workflow is always 'started' because there is a signal or scheduler activity

then you can just query how many activities (except for signals/schedulers) did not finish running - meaning the workflow is currently running.

You can do something like:

instance.vars.workflowId = <your workflow Id>

instance.vars.running=sqlGetDouble("select count(*) from xtkworkflowtask where iworkflowid= " + instance.vars.workflowId + " and tscompletion is null and sactivity <>'schedule' and sactivity <>'signal' ");

if instance.vars.running > 0 then your workflow is currently running.

Hope it helps,

Sagi

View solution in original post

David__Garcia
Level 8
Level 8

You can also use the following method to check various states/statuses for one/multiple workflows

Here are the enum mappings

======================================

@state

0-Being edited

9-Request to start in simulation mode

10-Start requested

11-Started

12-Pause requested

13-Paused

14-Resume requested

15-Stop requested

16-Stop in progress

17-Restart requested

18-Restarting

20-Finished

======================================

@status

0-Not started

1-In progress

3-Suspended

4-Stop in progress

5-Finished