App Studio - UBAQ Silent Param Passing - Help Needed

[dgreenEA (Dylan Green)]

Following the conversation had here for silent parameter passing:

Possible solution for silent BAQ parameter passing (working now)

Maybe I don’t understand your requirement, I feel there is a simpler way to do this, as explained in this post. Long story short: Use the rest-erp widget [image] [image] Configure the rest service [image] [image] Here is where you setup your BAQ parameters [image] Json syntax, to pass multiple parameters (as explained in the linked post above) [image] Define in which dataView the BAQ result will be saved [image]

and the conversation had here for getting UBAQs to work in a grid:

How To: Kinetic - Updateable UBAQ in a Grid

Ope hey der. It’s me! Jessica! [Rob Schneider Its Me GIF - Rob Schneider Its Me Sad - Discover & Share GIFs] Haven’t done one of these in a while and a good topic came up from another thread that I figured I’d make a more official post on. How in the heck do you wire up a UBAQ to a grid in Kinetic and, you know, actually make it update?! Drum Roooooolllllllll You gotta work for it. Boooo. This step is hopefully obvious, but go build your UBAQ. I’m not gonna get into that, t…

I want to combine these two items.

We have a BAQ with a parameter that needs to be populated silently without prompting the end user. I can get the BAQ to populate as shown in the first link and push it out to a grid. I can also set up the first bit of the UBAQ grid as shown in the second link.

I need help with the update part of the UBAQ conversation. I can create the event shown and make it work flawlessly. But, because the BAQ has a parameter, it prompts the user for information on the update and get calls.

I see in the second link that there is a conversation about using the same widget used to call BAQs with parameters silently. However, instead of executebyid it uses updatebyid. This does not include the executionParams option in the method parameters section. Trying to add a parameter here only lets me include strings and not datasets like in the executebyid version.

Is there a way to use the erp-baq widget with a parameter? Is there a way for me to include the executebyid version of executionParams?

[Randy (Randy Stulce)]

Just spit balling here but maybe use one BAQ to get the data with Parameter(s) and a second BAQ to update the database (without parameters).

[dgreenEA (Dylan Green)]

@Randy, I went ahead and removed the parameter from the baq and used a where statement that references the KeyFields table in the module. This seems to be working a lot better than my original concept.

Now I’m getting the following error and can’t seem to find my way around it. Any ideas?

[Randy (Randy Stulce)]

Looks like it’s trying to add a row that already exists instead of updating it?

[dmtorrice (Donna Torrice)]

I’m trying to do something similar–I’m trying to create a Customer Contact in a Panel Grid. I’m using kinetic-baq widget. I want to pass CustNum from Project to the Customer Contact. Is there a property to set the default value for the CustCnt_CustNum column?

[dgreenEA (Dylan Green)]

I managed to get rid of the “duplicate” problem by filtering the baq call with a where statement. I cannot get the update to fire correctly now. It goes through without an error, but the data does not update.

[dgreenEA (Dylan Green)]

Found my issue!

Following the conversation had on @hmwillett post I found the following:

How To: Kinetic - Updateable UBAQ in a Grid

@hmwillett In step 6, you’re adding columns from your BAQ, but it doesn’t look like you bind your grid to the dataview or BAQ until step 9. How do you properly add the columns you want to see? And is there a difference if you when adding them under Grid Model > Columns or Grid Model > Provider Model > Columns? I always seem to have an issue creating columns for BAQ Dataviews. If I do nothing under the columns it will return everything from the BAQ, but the column headings are ugly. I can’…

@zwilli526 mentions that all key fields for the update process on the baq have to be entered into the grid model, even if they do not need to be shown in the grid. In my case, I was trying to update anything with a blank key4 in the UD05 table. This is why the duplicate errors were pouring in. Additionally, that is why the rest enabled widget would call the updater, but nothing would go through. It’s because it was missing its required fields of company and keys1-5 for the update to be successful.

Thanks @Randy for taking a peek at this ane making me rewrite everything I had already done XD. I feel like I understand the process alot better and it runs alot smoother now without the parameter!

[Randy (Randy Stulce)]