Skip to main content
Answer

Dashboard table not working - Parameters not coming through

  • August 22, 2023
  • 5 replies
  • 148 views

ketiller
Jr Varsity III
Forum|alt.badge.img

Hello, 

I am having issues with a data table coming through on a dashboard, I currently have parameters set up on the GI and have it pulling in the dashboard parameters as well. Any idea why it's not populating any data?

Widget Properties: 

 

Inquiry Parameters:

 

Thank you,

KT

Best answer by BenjaminCrisman

@ketiller The “Inquiry Parameters” are coming from the underlying GI, not meant to be what is seen in the dashboard.

You can use the dashboard parameters to further filter the data being brought in, but there is not an expectation to have the Dashboard Parameters fill in for the Inquiry Parameters, these are two different sets of data control.

If you want the parameters sent from the GI to always have values in the dashboard, you can set default parameters in the GI, these will flow to the dashboard.

If you want to bring in more broad data and then use the dashboard parameters to filter this for the widget, then you use the Filter Settings and check the box as seen in your images.

When the end result is not bringing in any data then I would double check the GI and see if the parameters entered on the GI result in no data coming into the GI results, and if so, work to simplify or peel back some layers of the GI until it populates data as expected, then start adding the complexity back to the GI and once you have the GI working as expected with the given parameters, then work on the widget to see if it works better after the adjustments

5 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+17
  • Captain II
  • August 22, 2023

HI @ketiller 

Is this for all users or just you?


ketiller
Jr Varsity III
Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • August 22, 2023

@kandybeatty49 

Just myself, I am building it before releasing it to the user group.

Thank you,


Kandy Beatty
Captain II
Forum|alt.badge.img+17
  • Captain II
  • August 22, 2023

HI @ketiller 

On the Inquiry Parameters, try checking the Use Default Value. 


ketiller
Jr Varsity III
Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • August 22, 2023

Hi @kandybeatty49 

 

I am using the default value but still receiving the same error.

 

 


BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • Answer
  • September 12, 2023

@ketiller The “Inquiry Parameters” are coming from the underlying GI, not meant to be what is seen in the dashboard.

You can use the dashboard parameters to further filter the data being brought in, but there is not an expectation to have the Dashboard Parameters fill in for the Inquiry Parameters, these are two different sets of data control.

If you want the parameters sent from the GI to always have values in the dashboard, you can set default parameters in the GI, these will flow to the dashboard.

If you want to bring in more broad data and then use the dashboard parameters to filter this for the widget, then you use the Filter Settings and check the box as seen in your images.

When the end result is not bringing in any data then I would double check the GI and see if the parameters entered on the GI result in no data coming into the GI results, and if so, work to simplify or peel back some layers of the GI until it populates data as expected, then start adding the complexity back to the GI and once you have the GI working as expected with the given parameters, then work on the widget to see if it works better after the adjustments