GIs with parameters to have option to start search only after user presses GO

Not that I know of, but that would be an interesting idea. Sounds like a similar concept to the Defer Layout Update button in Excel pivot tables:

We have the same problem. I would also welcome an option to defer the search until specific parameters were completed. As a workaround, I sometimes default a field (e.g. InventoryID) to a lesser-used value so it will limit the returned data set on initial load.

As workaround you can just create a dummy parameter with Required=true and no default value. In this way the user will be forced to select it before the results are showed.

Where I had this kind of resource consuming reports, I created a parameter like this:

and in UI is displayed like this 

Hope this workaround will help you!

apara24 wrote:

As workaround you can just create a dummy parameter with Required=true and no default value. In this way the user will be forced to select it before the results are showed.

Where I had this kind of resource consuming reports, I created a parameter like this:

and in UI is displayed like this 

Hope this workaround will help you!

@apara24 

Thank you, I nearly missed this talent method. Sorry to reply late.

It is a really smart trick.

However it works for GI, but seems can not be played with Dashboard.

You see, on dashboard, it lacks the fill with combo box value like on GI. So, I can not put the <Combox> as a paramemter and set the list values.
Can you give me a direction on how to make your kind of trick happen on Dashboard?
Thank you.

Hi Alin Para,

This is really great idea. 

This trick is very useful when we have huge data in the system with multiple parameters in Generic Inquiry.

thanks for sharing with us.

ray20 wrote:

apara24 wrote:

As workaround you can just create a dummy parameter with Required=true and no default value. In this way the user will be forced to select it before the results are showed.

Where I had this kind of resource consuming reports, I created a parameter like this:

and in UI is displayed like this 

Hope this workaround will help you!

@apara24

Thank you, I nearly missed this talent method. Sorry to reply late.

It is a really smart trick.

However it works for GI, but seems can not be played with Dashboard.

 

You see, on dashboard, it lacks the fill with combo box value like on GI. So, I can not put the <Combox> as a paramemter and set the list values.
Can you give me a direction on how to make your kind of trick happen on Dashboard?
Thank you.

@ray20 

I tested on Dashboards and it seems that although Is required is checked for a dummy parameter, the dashboard brings data anyway. So this behavior looks like a bug for me.

Yes, you are right, the combo box is not present here, probably an idea on feedback.acumatica.com should be submitted.

I found a workaround for this but it is a little forced (I will write here only for info): you have to find an entity that you don’t use at all on your instance, and in this entity you can enter your action name (it must be an entity that have  a selector on it). For example , I used FOB Points :

Then, in Dashboards parameters , I put this in schema object and schema field like below:

Unfortunately, this is useless because the dashboards will refresh regardless of the value of the parameter “Is required”.

Converting this to an Idea.  Thank you for the feedback as this sure sounds like a useful feature.  Vote!

​@ray20 ​@Alin Para ​@Ali Jani Was there ever a solution to this for Dashboards? Was an Idea ever created?