How To: Kinetic - Updateable UBAQ in a Grid

Yea i found log. But I dont understand why it finds as an issue since this field isnt updatable. This happens only if I send all rows. Took this line and updated as single and it worked. Even in classic there is no complains.

![CDATA[System.ArgumentException: The input string ‘4500.708’ was not in a correct format.Couldn’t store <4500.708> in Calculated_SumOnhand Column. Expected type is Decimal.

Payload passes these values as decimals 4500.708 not as string ‘4500.708’

1 Like

What happens if you go into Data > Grid > Columns, find that column, and then explicitly set the type to be a number?

The same (if you mean editor type). I tried to remove all rows from baq and leave 3, server still complains, but about another field which allso says incorect string format, expected decimal :confused: It seams somehow send all rows passes all decimals as a string I guess, but in payload object are passed as decimals without quotes

This worked great! Thank you.

I’ve noticed that when I convert an updatable dashboard it adds an update option but when I build one from scratch it does not so I found this post and now have a ghost icon that lets me update :slight_smile:

I have followed the instructions and I am able to update my date but when the refresh on the last trigger it brings in the complete baq instead of just the line that matches the sales order I am in. I tried to put information in the properties of the kinetic-baq get widget but then my data doesn’t update. Any suggestions?

very usefull

1 Like

Thank you @hmwillett - very helpful!

2 Likes

I’m having an issue with this, hoping the brain trust may have some ideas.

I added a grid and form entity to Job Closing for capturing a job comment on the job header (CommentText). UBAQ works fine testing in BAQ editor, it’s firing off the update BAQ just fine, and updating the view as expected. But not committing the data.

Things I’ve double Checked

  1. Tested BAQ in the editor
  2. double checked grid and column are editable
  3. Published, saved reloaded
  4. Tried trapping in F12 via chrome, the request goes out to the update function with all the pertinent fields, but returns blank.

Any ideas?

Screenshots for context

View loaded via BAQ initial get triggered after getById into View “Comment”

Save button action

Do you have a data binding on that text field that you’ve added?

Yes, it’s bound to comment.JobHead_CommentText which is the view of the ubaq

1 Like

Bumping this one up a month + later as I still haven’t been able to figure out why it will not update.

A little refresher ..
Added a comments field and a UBAQ grid to the Job Closing form.

The BAQ has been tested in BAQ Studio and that part works fine.

However even though I’m not getting any errors the data is not being updated in App Studio.

Button Action

When testing via Chrome I can see the BAQ get called just fine

But I get an empty (but successful response)

Any other ideas?

Are you just updating the native Job Comments field from the JobHead? Is that not already part of the dataset that pulls the rest of the information, or is it not and that’s why you’re using a uBAQ?

Reason I ask, is because if it’s already part of the natively available dataset, you should be able to simply add it to your screen and when you click the page save icon it will write to that field, too.

2 Likes

I’m going to agree with @d_inman that this may be in the existing dataset and you don’t need a uBAQ to update it.

2 Likes

It’s unfortunately not part of the data set on jobclosing. Job Closing has its own little subset of the jobhead dataset.

2 Likes

Maybe try setting RowMod to “U”

What method are you updating in the BAQ? Custom directive or base?

1 Like

Try setting rowmod = U like JB said.

How would I go about doing that in App studio, I don’t think I’ve done that before

1 Like

A new wrinkle, I used row-update to update that, however since these are looking at jobs in the rear-view I get this error trying to update commenttext on the jobhead