I have started to move my classic dashboards to the Kinetic environment and have run into a stumbling block that seems to be so simple and yet I cannot figure it out. We have many dashboards that have a parent/child relationship in where we filter the parent table and the grids of the child data filter based on what was selected. When I deploy these, Generate Application, in general, the dashboard come out in pretty usable condition needing some minor tweaks for appearance. However, when I select a different record in the parent grid, the child grids do update. If i go to each grid and “Refresh Grid” the data then filters properly.
I have looked at a lot of posts on parent/child grids and reviewed a lot of settings and everything seems to be setup correctly to work. I can’t help but think this is something simple I am overlooking.
It’s likely because the uplift does some weird stuff with setting a TransView variable and then the subscribing grid filters off of that. I’ve found it’s much more reliable if you subscribe directly to the publishing grid’s dataview.
Okay, the Publishing dataview is ELA_CAJobs_Main_0_0 so I changed it to
‘?{ELA_CAJobs_Main_0_0.JobHead_JobNum}’
and that allowed the grid to filter initially but it still did not refresh after moving to the next record in the publishing dataview. This change makes sense as it mimics the filter in the classic dashboard. However in classic, it filters properly.
The Value that is cut off is: '?{TransView.ELA_CAJobs_LaborBdg_4_0_JobHead_JobNum}'
When I change the Value to this: ‘?{ELA_CAJobs_Main_0_0.JobHead_JobNum}’ I get the same effect. The ELA_CAJobs_Main_0_0 is the publisher BAQ.
There does not seem to be any view options that I can see.
This is how it works - When the screen loads and you hit the refresh button, you get a drop down to provide a value for the parameter in the main BAQ. The main data loads and the rest of the child grids should filter based on the selected line in the parent grid. If the grid is visible, the data will refresh. If it is not visible, it will not refresh. When you change the selected row in the parent grid, nothing refreshes but it does look like to tries to. You see a brief spinning wheel.
Sorry if is a lot of info, I just wanted to make sure I was conveying the situation completely.
I have messed with this all weekend and no luck. It seems like the filtering is working when you refresh the subscribing grid but it requires a manual refresh every time you change the publishing grid’s selected row.
Not sure what to try next. Should there be a refresh event?
