I will try to lay this out as cleanly as I can so it is easy to understand. Almost everything I have built in Kinetic was as a result of @hmwillett 's documentation and discussions on this forum.
The updatable BAQ works in the designer, so let me know if you still need the details on how it is built.
BAQ Update Settings:
I created a simplified dashboard to test with and here is how it is laid out.
I used the New > Dashboard in Application Studio.
I named the dashboard.
I added a new DataView using the Data View Guided Setup.
BAQ Source Type.
Entered BAQ and Data View Name.
Allowed it to generate the default entries for DataView and Event.
I edited the main page and added a new Panel Card Grid.
I used the Guided Setup to select the Data View and mark it as Allows Updates, then selected a name for the grid and chose which columns I wanted to be visible and updatable, and clicked Finish.
I clicked on the pcg, expanded “Data”, and clicked on “Grid Model”, then “Provider Model”.
I entered the Ep Binding for the new Data View and entered the Baq ID, and set Is Default and Auto Refresh grid On Load.
I went back to the metafx-panel-card-grid, expanded “Advanced”, and clicked on “Action Data”.
I added 2 buttons, 1 for refresh and 1 for update. I gave them a name, a description, an icon, and checked “Add to Primary ToolBar” for each one.
I created 2 custom events.
The one for the Refresh button is a simple Control onClick and then a property-set. The Parameters for the property-set are the name of the pcg and Props is set to “Prop > invalidated” and " Value > “true”".
The second one for the Update button is another simple Control onClick and then a kinetic-baq. The kinetic-baq is set to the BAQ and View Name I created earlier and then “Mode = update” > BAQ Update Options has “Operation = update” and “Send All Rows” = checked.
When I test the BAQ in the BAQ Designer, I can edit multiple rows and then Update, and it takes about 5 seconds to process. When I test the updatable dashboard in Application Studio (or use the deployed dashboard from the menu) they take around 5 minutes, receive an error that the job is closed, but will typically save the data for me.
If I uncheck the “Send All Rows” and test in Application Studio, I tried updating 7 rows, then put the selected row on the 8th row and when I clicked Update, it didn’t save any of the values I entered. It did update in about 1 or 2 seconds, but didn’t update the rows I needed.
Let me know if you need any other details or if you need me to try anything.