JS to check if a workflow is running | Community
Skip to main content
maurizio_coro
maurizio_coro
Level 3
Oct 29, 2018 9:42 AM UTC
Solved

JS to check if a workflow is running

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
sagi_laniadoAccepted solution
Level 3
Oct 29, 2018 12:08 PM UTC

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 reply

3 replies

david--garcia
david--garcia
Level 10
Oct 29, 2018 4:36 PM UTC

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

Translate
maurizio_coro
maurizio_coroAuthor
Level 3
Oct 29, 2018 3:40 PM UTC

Perfect! Thanks

Translate
sagi_laniadoAccepted solution
Level 3
Oct 29, 2018 12:08 PM UTC

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

Translate
Terms & ConditionsAccessibility statement

Loading footer...