Skip to main content
S
santhoshp0005
February 2, 2022
Solved

update data

  • February 2, 2022
  • 3 replies
  • 0 views

hi i have one editable grid i fetch data from one table to that editable grid so in my table items quantity is fixed

so when i add items to that grid the fixed quantity is modified

example:when a user raised a request he order 10 items 

so when i accept the order the items of the fixed table is automatically updated so how can i do it

    Best answer by gopalk2865

    HI Santosh , in this case you would need to calculate this value on your "Accept" or "Approve" button's Save into parameter or after task approval ,you can add a script task node to do the calculations before finally writing to db .

    3 replies

    gopalk2865
    gopalk2865
    Participating Frequently
    February 2, 2022

    HI Santosh, If i understand correctly then you want to write modified values to db on "Accept". Let me know if i am wrong . In this case , After approval task , add gateway and based on yes or no you can write your data using write to datastore entity.

    S
    santhoshp0005Author
    February 2, 2022

    i will explain clearly

    iam doing inventory management application

    so i maintain one database for inventory items ihave fixed items with fixed quantity

    so when user order some items i get that data

    so when a approved for example user oeder 10 laptops so when i accept the order i need to automatically update quantity for exapmle quantity is 100  user order 10 so  next time  i got any order of laptops my quantity should be 90 so this is my reqirement so hoe can i do it

    gopalk2865
    gopalk2865Answer
    Participating Frequently
    February 2, 2022

    HI Santosh , in this case you would need to calculate this value on your "Accept" or "Approve" button's Save into parameter or after task approval ,you can add a script task node to do the calculations before finally writing to db .

      Terms & ConditionsAccessibility statement