Small and medium business | Business Central, N...

I'm not able to find the correct table for WORKFLOW, from where we can update the workflow steps in a bulk.

(0) Share

Report

Posted on by Surabhi Dobhal

Hello All,

We are updating the workflow and its steps for individual approvers. How can we update the workflow steps in a bulk?

For Example: For one approver, we need to update the amount limit who is a part of many approval workflows, manually we can update highlighted field but from which table we can update the amount for too many workflows? I'm not able to find its respective table from where we can update the data thru SQL query.

I have the same question (0)

All responses (4)

Answers (0)

JAngle 127 on at

Like (1)

Report

RE: I'm not able to find the correct table for WORKFLOW, from where we can update the workflow steps in a bulk.

Workflow step buffer appears to be the table. Basing that on doing a page inspection/about this page on the list part. Generally helps you identify any table.

docs.microsoft.com/.../using-about-this-page-and-about-this-report

Was this reply helpful? Yes No
Vanessa Garcia on at

Like (0)

Report

RE: I'm not able to find the correct table for WORKFLOW, from where we can update the workflow steps in a bulk.

Exactly

As Josh stated the table including the information about the Condition is Table 1507 - Workflow Step Buffer.

Cheers,
Vanessa.

Was this reply helpful? Yes No
Surabhi Dobhal on at

Like (0)

Report

RE: I'm not able to find the correct table for WORKFLOW, from where we can update the workflow steps in a bulk.

No table was mentioned for "Event condition page". Also Workflow step buffer table is a bit tricky. Field "Condition" is of "Text" type. and where data is being stored for "Filter Page"

Was this reply helpful? Yes No
Suggested answer

Greg Enns 1,106 on at

Like (0)

Report

RE: I'm not able to find the correct table for WORKFLOW, from where we can update the workflow steps in a bulk.

I would tread very lightly here and be sure you're working in a testing environment and not production. It MIGHT be possible to do what you're doing, but I definitely agree with it being "tricky". From what I've seen OOB workflows were intended to be functionally extended with code but not really created or modified with code.

Do let us know if you're able to make some progress though.

Was this reply helpful? Yes No