How can i make my updatable dashboard to save data more faster

[JasonMcD (Jason McDermott)]

Curious - are you saying 25-60 minutes per row? Or for the whole list? Assuming the whole list.

So, I ran into a similar-ish scenario when trying to update the MfgComment field on JobMtl.

Is there an alternative to the JobEntry business object?

I want to make a REST call to update the MfgComment on JobMtl. I did a trace in a few places and they all use the JobEntry business object. The huge downside to this is that that BO will download the entire MOM of the job even if you only want to update a single row of JobMtl. Small jobs, meh, fine. But I looked at one job for a truck we build and it has 1,799 JobMtl rows 485 JobOper rows 110 JobAsmbl rows So it takes 21-33 seconds to pull all of that info into the update task even though …

In that case I was making an Epicor Function, but still, I was using a business object to update a row, just like you are. It would take 30 seconds per row, and DMT was the same way. The problem was that the system’s methodology was to pull in the entire Job (the JobEntry BO) and then update a single item in it. I learned there how to pare it down to the single row I needed and now it works in milliseconds.

So… I don’t really know how to apply the same logic here to a uBAQ, but maybe someone else does…?