Skip to main content

Notifications

Announcements

No record found.

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

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

Posted on by 80

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.

pastedimage1630225689835v1.png

  • Suggested answer
    Greg Enns Profile Picture
    Greg Enns 1,102 on at
    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.

  • Surabhi Dobhal Profile Picture
    Surabhi Dobhal 80 on at
    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"

  • 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.

    pastedimage1630321977427v1.png

    Cheers,
    Vanessa.

  • JAngle Profile Picture
    JAngle 33,159 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans