App Studio UBAQ Invalid Employee ID Error

[CMoerchen (Camryn Moerchen)]

Hello!

I’m currently working on an updatable grid for a Kinetic Dashboard that displays labor transactions. The grid is populated using a UBAQ, where the fields being updated are apart of the LaborDtl table.

To build the grid, I used this tutorial which has worked without issue for my other dashboards: How To: Kinetic - Updateable UBAQ in a Grid

The UBAQ updates correctly in the classic version of the BAQ Query Designer, but when I try to perform the update in the preview of my dashboard, I get this error:

I checked and my employee ID is accurate in the Constants table, and reviewed to see if we had any BPMs that might be causing it. I have used the tutorial for other UBAQs that use the LaborDtl table, but for some reason this one isn’t too happy.

Does anyone have any advice for what the issue could be or methods to troubleshoot?

Thank you!

[CMoerchen (Camryn Moerchen)]

I was able to solve this error! I wasn’t including the EmployeeNum in the LaborHead in the UBAQ. I’m not sure why this caused an issue in App Sudio but not BAQ Designer though?

[JasonMcD (Jason McDermott)]

I’ve only skimmed this to be honest, but it may be what I ran into a while back, that the Data View doesn’t have enough info for the BAQ.

Kinetic updatable dashboard would not save record because

Spent entirely too long figuring this out today, but I did, so I wanted to share this for my future self and anyone else. First, what are we calling this thing now? Updatable dashboard (still)? Kinetic uBAQ app? Well whatever it is… In short When you make one of these things, you have to include all key fields in the columns of the Panel Card Grid in Application Studio. (Or for Company, you will be fine if you use Constants.CompanyID inside the uBAQ.) The story We have an updatable dashboard …

[CMoerchen (Camryn Moerchen)]

Ah okay that makes sense! I think going forward I’ll use that strategy instead of trial and error , thank you!!