How To: Kinetic - Updateable UBAQ in a Grid

Not sure there’s a way around that, short of programming BPMs to un-engineer your jobs, save the changes, and then re-engineer/re-release (depending original status of the job). Unless you are ok with allow changes to engineered jobs, then you can change that setting in Company Configuration (Modules > Production > Job card).

image

Other option could be to store these comments in a UD table that stores the Job Num and this comment that you’re trying to save. Of course, that’s not going to be the same as the job header comment field, but you could then also add this field to the JobEntry application.

I got it working finally. The rowmod was the key, but also I was able to send a jobhead.engineered = false which allowed me to save but because that’s not an eligible field for updating in the BAQ leaves the status alone on the jobhead record.

For future me (and anyone else that may find this useful)

First row-update

Second row-update


I have been working on trying to add and remove records from my grid using events, this has stumped me for around a month I was hoping someone would be able to help me out as it does not seem to be an intuitive task.

Ive documented most things here: Deleteing and Adding Records In a uBAQ Grid using Events

Comedy What GIF by CBS
Why is Kinetic this confusing to use???

This is a great tutorial but I have run into a snag - my UBAQ has a parameter. When I load the grid, I now get the parameter fly-out. Once I get past this, the update seems to work fine. I’m thinking it has to do with the Provider Model but there is only a Where Clause area, no Parameter.

Any thoughts?

Refactor your UBAQ to not use parameters, upgrade to 2026.1, or play with loading the data using an event since the baq event widget lets you pass silent parameters.

I’m curious - how has this behavior changed in 2026.1?

You can pass parameters from the provider model in 26.1.

Thank you for the great explanation! :grin:

I am having some trouble with this.

The Ubaq is setup and works fine. I have made a panel card grid that uses the Ubaq, this is set to editable. The dataview is also setup and refers to the Ubaq. The column that needs to be updated (QuoteHed_QuoteComment) is also set to editable. The event for saving has been made using your instructions. When opening the dashboard however, I can’t select the column/type in the field that needs to be updated.

I have also made a text box that refers to the same field, that one works fine (the button with the update event also works for this).

For now we should be able to use the text box for updating the comment, but it would be nicer to be able to update the field directly in the column.

Probably missing something obvious.. Anybody an idea of what that could be? :sweat_smile:

Thanks Hannah - I think I will try to change the BAQ to not use the parameter and see how I get along.

BTW - thank you for all the great content on this site! It has saved me numerous times in my journey to get to the browser.

Ed

Changing to a UBAQ without a parameter did the trick - thanks.

Ed

This worked great to create the custom Part layer and update an existing row in the UBAQ, which is a child UD03 record to the Part. Thank you!

Now the issue. I can’t get the layer to add a new UD03 record. Key1 is PartNum and Key5 is a sequence. I have an event that does fire when I click the new (+) on the grid, but then no empty row is available to update. Depending on how I set it up the grid does flow to the bottom, like it thought there would be an empty row, but it isn’t there.

Does anyone have instructions on setting up the new record for a UBAQ DataView.