Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
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

Categories:
  • 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,155 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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans