I have a grid panel bound to a dataview, that is pulling from an updatable BAQ.
I can change the field values in the grid, but when i select update, it does not actually stick. I have the event calling Kinetic-BAQ
If I change one of the fields in the grid. I can then call an event which sends this:
I tried following this guide, but i can’t seem to get it to update.
In Grid Model - Columns, is the Editable checkbox checked for the fields that can be edited?
Just noticed that, was just trying things (Trying to replicate how Epicor did it natively when upgrading a classic dashboard into kinetic, basically using two mirroring views, when one changes, change the other, then push the other to update). I put it back to QuoteHead, still no update.
In your BAQ can you show your update screen
You uBAQ works by itself?
Correct, works in the classic dashboard too.
Sometimes the layer gets corrupted. I’d try again from a fresh layer.
Are all the columns required for the update defined in the grid view? ( you can add the extras and hide them after)
Also, you could try adding a row-update before the BAQ that sets QuoteHead.RowMod = “U”
Shot in the dark here, but does the kinetic version send in both rows? (an updated and the unchanged row). I vaguely remember that kinetic only sent in a single row (the one with row mod U) and that made it so the update didn’t work?
I could be totally wrong though.
I think you could probably debug that with some message boxes.
I just checked my dashboard that uses a uBAQ and it’s calling a Function I created to do the actual call to the BAQ. To bypass issues that @Banderson and @mzahn mention above.
RowMod setting didn’t do anything, and a new layer did not help.
When you say you called a function, how were you able to pass it a dataview? That could work if I was able to get that.
Did you check that all the baq update required columns are defined in your gridview?
Ours is updating a UD table and we use Key5 as the unique ID field, like SysRowID in a way. So the dashboard sends all the changeable fields plus Key5. The function takes in the input and either makes a new row if the inbound Key5 is blank or updates the row with the provided data.
This is key too, all the uBAQ columns need to be in the dataview. They can be hidden from the displayed fields but must be in the dataview.
Ahhh clever, gotcha.
Most are in there, I am missing three key fields, but they are being set elsewhere in the UBAQ (set as predefined variables like “QuoteHead”) instead of a column value. They aren’t even display fields in the UBAQ
