Hi Pooja,

For this type of requirement you need to use BPT process to achieve this.

Thanks 

CV sharma 

Hello there pooja,

Hope you're doing well.

So it seems that you have this value (stock) stored as an attribute in the database.

By the time that a customer buys 5 items of a medicine, you will need to call a Server Action in order to fetch that medicine record (using an Aggregate) and you should update the stock attribute with the correct value.

You should update this record (in the stock attribute) by calling Update<Entity> action. So inside the Server Action, you will need to call this action to update the value for the new available stock. You just need do update the specific record of that medicine with the correct value for the new stock.

Hope that this helps you!

Kind regards,

Rui Barradas

Hello Pooja.

A dynamic update would mean "for each order created, update my table".

The normal way is, call an action to update, based on how much you placed on the order.

-You have product id and quantity.

-You search inventory by productid, edit that record to minus quantity, and do an update.

I made this example where you update stock. If the number is positive, you add stock. If negative, you remove stock.

Hi Pooja,

You can use the sum of customer's purchase item to calculate the item quantity.

You can substract the sum of  purchase quantity of customer's entity  from item quantity of stock entity, and use create and update action of stock entity.

Hope this will help.

Regards,

Komal