Question

Updating an attribute in another entity!

0

Hello, I am creating a small app for managing stores and employees working in stores. Its a 1-* relationship between both entities Stores and Employees. I have a field in my Stores entity called “countOfEmp”. My plan is for this field to get automatically updated “hopefully through a Microflow” whenever I add/edit/delete an employee in the Employee entity. Please advice on how to best approach this?

asked 2023-09-14

Mohamad Saleh

6 answers

Sonam Kumari · Answer 1 · 2023-09-14

Hi Mohamad Saleh,

For this, you can add an 'After Commit' and 'Adelete' event handler on the 'Employee' entity and can add the logic in that microflow to update the count of employees for the associated store. So, in this way, whenever you commit or delete the employee object, the configured event handler microflow will be triggered.

You can refer to mendix docs as well: Event Handlers | Mendix Documentation

Thanks,

Sonam

Mohamad Saleh · Answer 2 · 2023-09-14

Thanks. What kind of activities should I include in logic? See attached

Mohamad Saleh · Answer 3 · 2023-09-14

Thank you, Sonam.

It works great now when adding new employees. It appropriately updates the count whenever I add a new employee. Should I create another workflow to update the count whenever I remove an employee from a specific store?

Mohamad Saleh · Answer 4 · 2023-09-14

Still not working, folks!

Adding a new employee will update the count just fine. Deleting an existing employee won’t update the count. Here is what I have so far in my workflow!

Mohamad Saleh · Answer 5 · 2023-09-15

Thanks Sonam,

Can you please elaborate a little more to this?

Here is what I have for my store “Retrieve Object”

Mohamad Saleh · Answer 6 · 2023-09-15

And here is what I have for my list Of Employees “Retrieve” object