Prevent Grid for auto loading in Kinetic Dashboard

Is there a way to stop a dashboard from auto returning results upon initial load?

I want users to enter a filter/tracker value first before anything loads in the grid. I tried created an Override on Form_OnLoad, but the grid still populates automatically.

Hacky… but you could set the grid to not be expanded at runtime. The BAQ generally won’t fire until you expand the card.

1 Like

Hacky is always a solution.

I went a slightly different route for this case, but the expand at runtime will be useful some other use cases.

In this instanace, I used row-update on the Form_OnLoad that forces a value into my filter. This at least stops the inital load.

3 Likes

Interesting solution and I kinda dig it.

Another option is to not use the provider model on the grid and, instead, bind it to a dataview. You could then have a button that executes the erp-baq event to populate it.

2 Likes

Or to give more options :slight_smile:

In the provider model of your grid you would have put a ? Or ?? In front of the Part Number filter field.

I can never remember which is which of by heart but if you put ? Change it to ?? And if you put ?? Change it to ?. As one of them doesn’t make the call if the field is blank / null.

2 Likes

Single question mark means it has to have something to run.
Double question marks means it will run regardless and send an empty value.

5 Likes

Thats it. Thanks.

So single for more of a publish and subscribe.

Double for ‘optional’ filters.

1 Like

I was about to ask the multitude of other users on here that can’t get their grids to populate to chime in and let us know how they were pulling it off… but… sounded a little TOO sarcastic :smiling_imp:

2 Likes

The downside of this is if you leave the panel expanded and one filter criteria isn’t enough to make your dataset small enough, you’re going to get a massive return the moment you tab out of the first field unless you single question mark ALL of the criteria which can be annoying if not by design.

I like to control how the grid expands for things like that.

undefined

2 Likes

These are all solutions.

The Single ? is actually what I was looking for I think.

4 Likes