Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

JS to check if a workflow is running

Avatar

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

Avatar

Correct answer by
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

Avatar

Correct answer by
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

Avatar

Community Advisor

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