how to identify proper workflow id?

(0) Share

Report

Posted on by Community Member

Hello, I've created a new on-demand workflow named "MyWorkflow" and I need to execute this from js. I found SDK.SAMPLES.ExecuteWorkflowRequest js which I plan to use for this purpose. As part of this process I need to specify the w/f id. I ran the following query to identify the lookup table for this:

select * from information_schema.tables
where table_name like '%workflow%'

Workflow/WorkflowBase seem to be the proper lookups for this. However, WorkflowBase returns 2 rows that have different WorkflowId's but which have a matching workflow name of "MyWorkflow." So how can I decide which row to use? I noticed the following data pattern:

Match #1: ActiveWorkflowId is not null, ParentWorkflowId is null
Match #2: ActiveWorkflowId is null, ParentWorkflowId is not null

So my first impression is to go with the WorkflowId for Match #1. Is that the correct choice?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (3)

Verified answer

Karth on at

Like (1)

Report

How about retrieving the workflow ID from the workflow form URL?

For example - --https://myorg.crm.dynamics.com/sfa/workflow/edit.aspx?id=%7b44A1722A-2D32-4065-803D-9472126BB4E4%7d

Was this reply helpful? Yes No
Verified answer

Guido Preite 54,086 Moderator on at

Like (0)

Report

Karth is absolutely right, you can get the Id by CRM UI:

Was this reply helpful? Yes No
Verified answer

ScottDurow 21 on at

Like (0)

Report

Hi,

If you need to get the ID dynamically from the workflow name you can do this using the REST endpoint - see sliong.wordpress.com/.../crm-2011-runningexecuting-workflow-using-javascript

You could a library such as the XrmSvcToolkit or XrmServiceToolkit to easily execute this REST request:

"WorkflowSet?$select=WorkflowId&$filter=StateCode/Value eq 1 and ParentWorkflowId/Id eq null and Name eq \'' + workflowName + "\"

This would only really be needed if you have a situation when you only know the name - if you create a workflow and add it to a solution, it will always maintain the same ID when deployed to another organization so it's ok to hard code the ID.

Hope this helps,

Scott

Was this reply helpful? Yes No
Suggested answer

Vipin J 1,603 on at

Like (0)

Report

The context, where you mentioned about Match #1 and Match #2 is correct.

I was also looking for some answers, as I wanted to cancel the waiting workflows (specific one) for some business scenario and found that there are multiple workflows of same name.

They get created as when we activate and deactivate them.

I have written a blog around this, hope it might help you.

http://vjcity.blogspot.in/2017/12/cancel-workflow-using-javascript-and.html

Thanks.

Was this reply helpful? Yes No