We’ve noticed an issue with the refresh function within a Kinetic dashboard that drives off multiple BAQ queries.
For example, we want to select a line/quote from the top table and have the rest of the grids auto populate based on what is selected. To do this we need to click on say the 10019 line then we have to manually go into the other grids overflow menu to Refresh Grid from there.
Clicking a line in the top grid doesn’t automatically return any results in the other grids:
We have no parameters currently set, could this be the issue? QuoteNum would be common link against some of the queries but not all, where PartNum is then the link.
We were also trying to find a solution in creating a new layer and getting a refresh event to look at all 4 grids?
If you tie your first BAQ grid to a dataview, you should be able to use a Column from that dataview as a parameter in the Provider Model of the sub grids.
Here’s an example… the top grid is tied to a DataView (which is itself populated by a BAQ): “PartAvailView”
There are multiple subgrids that are directly tied to BAQs. When I select a row in the top grid, all the subgrids update based on the selection.
Enter your BAQ in Provider Model, and in BAQ Options, you set a parameter that drives the data:
In this case, the PartBin_PartNum of my subgrid BAQ needs to be equal to the top grid’s PartNum… in this case stored as PartAvailView.PartMtlLv1_MtlPartNum
This dashboard has (5) sub grids… when I click on a row in the top grid, I can see in Debugger > Network that (5) BAQs fire:
Gents, not to hijack this thread, but the publish/subscribe functionality of dashboards should be enough to enable the refreshing of subordinate grids, yes?
Brilliant, thank you so much David!!! Really appreciate the screenshots too this is really helpful!! And in going through these replication steps, we’ve stumbled across the below hidden tick boxes which since enabling has resolved one of the issues!
Just noticing how you’ve displayed the grids on your example, it looks like you have a collapse/expand option on the panel, is this something you added in please?
For example, ours is just fixed as open with no option to expand/collapse
I honestly didn’t read the rest of this thread because I don’t have enough caffeine in me to pay attention, but yes–pub/sub should be all that you need and I use it frequently.
Hmm… I have a dashboard doing exactly what the OP identified. I can select an item in the top grid and expect the bottom grid to refresh automatically, but it doesn’t.
Apparently David, and now the OP, have found that a customization layer is required to make this work.
I’m hoping that’s not the case, but it sort of looks like it is… My bottom grid does NOT auto-refresh. I have to use the overflow menu and click refresh grid - as in the original post.
Still testing this now, but creating a new layer then enabling the auto refresh options (Grid Model > Provider Model) on each grid, looks to of resolved the issue.
