Set a Kinetic panel grid to open with Preload Data mode turned on automagically?

Hello again,

I’d like for a panel grid on a dashboard to look like this when I expand the panel:

In the debug, I found these properties on that panel grid:

metafx-panel-card-grid

gridModel : panelCardGrid : pagingModeBehavior :

preloadButtonIsActive boolean
showFilterButton
showGetMoreButton
showPreloadBanner
showPreloadButton
showPreloadConfigAction
showSummariesAction

preloadRecordCount integer

I set all the booleans to true, but when I expand the panel, the preload button doesn’t show up until after the query runs, and then it isn’t activated.

I’ve tried setting these properties after form load, on panel expand, and after the query refresh event runs.

The users want to sort by data, and the sort doesn’t work until all the rows are loaded.

Has anyone been successful with this?

Thanks,

Joe

I know there’s a “pagination” checkbox in the grid set up (in current versions). Not sure if that’s checked by default or not. But i always assumed if that was turned off, you’d get all records by default.

EDIT: Found it this morning… “Pageable” not “Pagination”

1 Like

I’ll check it out. Thanks.

That didn’t seem to make a difference.

Joe

1 Like

But flipping these two check boxes is looking promising:

That was changing the page size, too?
In @dcamlin’s screenshot shows just 100, but if you put 2000, that would cover your results

I thought the Auto Load Grid was for automatically loading the columns from your BAQ. Basically so you don’t have to program each one inside the “Columns” menu. But, could be wrong about that.

That could be. I’ll be checking. Thanks.

Hi Joe,
Were you able to preload all records for the dashboard and what was the solution? I have the same issue.

For my Kinetic dashboard, the users must click the preload icon to load more rows of the data. The sum at the bottom is not accurate because it doesn’t contain all the rows. Even clicking the preload button will not load all the data.


The user needs an additional click to Get More rows.
image
I fear the users will forget to load all the data and misreport the summation.

Thank you for the support.
Heide

Heide,

Do you have the provider model set up like this?

Thanks,

Joe

1 Like

That is the solution. Thank you Joe. You are the best!

1 Like

Good deal. Thanks, Heide.