Question

BPM to update a table?

  • 20 May 2021
  • 2 replies
  • 381 views

  • Anonymous
  • 0 replies

Hello friends,

We have a dashboard which contains a BAQ based on the JobHead table. In that table, we have a custom field for estimated hours, which is typically updated manually, one job at a time. What I would like is to build in a button in the dashboard such that when it’s clicked, it takes the LaborHours data for each Job in the LaborDtl table and copies it to the custom field in the JobHead. I’m still very green on BPMs, so would a BPM be the best way to handle this? Method directive vs. data directive? And should the BAQs themselves be updatable? Any advice is appreciated.

Thanks,

Matthew Morgan


2 replies

And I only realized after submitting the post that the LaborDtl can have many rows for a single Job Number, in which case I’d need to aggregate the LaborHrs by JobNum and write that data to the JobHead…

Userlevel 2

I think the information you are looking for is in the job assemblies table. It has both total and estimated time and costs in it.

Reply