I am struggling with getting the JobAddInfo data to pull into the End Activity screen on MES using a rest-erp. The field I particularly want is the “Qty Left” field.
I followed the thread below, but I am still getting an error:
When opening the End Activity screen, I get a correlation ID error. After selecting okay, I can see that a value pulled into my UD field for Qty Left, but it pulls in the string value (Ex: {JobAddInfo.QtyLeft})
The end goal of this customization is to give the end users an idea of what is left to do on that operation. We have a lot of issues of over clocking qtys and a big reason why is because there is no communication between users to know what qtys were already clocked.
This is my first time working with rest-erp, so I know there is most likely something I am doing wrong. Any guidance or other ideas would be greatly appreciated!
The “value” of your row update has quotes around it, so it’s going to pass a string.
If you take the quotes away, it should pass a number value.
… at least that’s my first thought.
Also, as @hmwillett mentioned, reviw your rest request & response. Make sure you check if there are more than 1 parameter that needs passed. I often fill in the first one (ipJobNum in this case) but forget to check if there are additional ones that need accounted for. Since this is being used to end production activity, i wouldn’t be surprised if there were additional parameters for AssemblySeq and OpSeq. Not by a computer at the moment to check, sorry.
I will double check this. I think the issue I was having is that I would set up a dataview, add columns and what not, but when I would save and refresh, all my columns would be gone. Is that normal? Am I not supposed to create columns but just a dataview to call to? I apologize for any ignorance, lot of my Application Studio training is self-taught.
I was able to figure out another route using a BAQ. I created a dataview with from the BAQ and have it doing a GET erp-baq after the AfterIntialize event. This works as intended.
Now that I know I have something working, I can play with the rest arguments. It would be nice to use a rest instead of a BAQ, since the BAQ can be manipulated after the fact. I appreciate the responses! I will see how it goes!
The columns should come in by themselves when you enter the Data Table in the DataView setup… you shouldn’t need to add them.
I believe this could be your problem…
The table you want to be referencing in your DataView is JobbAddlInfo, but you may have put JobAddInfo.
Not “Job-Add-Info”… but think, “Job Additiona L Info” : JobAdd-(lowercase L)-Info.
Check the Data Table used in your dataview for that missing L and see if that brings in the columns. You’ll have to double check all your bindings to make sure you get that L in there, as well.
I was able to get it to work!! @dcamlin and @hmwillett were both correct.
I created the DataView for JobAddlInfo and made sure to update my bindings to have the “l” in between Add and Info. I used the Wizard to create the DataView which let me set up the Response Parameters at the start and have events pre-made to edit.
Once I got it all set up, the data pulled in as intended and was able to do the customizations I wanted. Thank you both very much. Made the troubleshooting process ten times easier.
