E10: Adding drop-down/filter option for Updateable BAQ Dashboard

Epicor ERP 10
, ,
1

Hello,

I was wondering if anyone knows or if this has been successfully done to create a drop-down or filter text box in a BAQ updateable dashboard please?

In this example, I’m trying to make a filter for the ‘ProdGroup’ field, the ‘Release Comments’ field is the only one updateable.

Many thanks in advance! :slight_smile:

image
image1079×267 5.95 KB

2

Welcome Michaela!

I do this in my dashboards all the time. Here is an example where I have a drop down box populated by a BAQ. I adjust the parameters for the BAQ based on another textbox or drop down box.

Enter Value in BAQCombo from Customization - Kinetic ERP - Epicor User Help Forum (epiusers.help)

Good luck!

3

That’s great, thanks for your help Nate! :slightly_smiling_face:

4

I would avoid the customization and just do this in the BAQ. You can make the fields update able, but don’t actually make it update-able in the dashboard. Then it will automatically be a drop down filter in the dashboard without customization.

3 Likes
5

Hi Brandon,

Thanks for sharing this, this has been a major help! :slight_smile:

So far got the drop-down / customized the tracker view but I’m struggling to see how to get the tracker and the grid to communicate - currently when I select something in the drop-down of the tracker, the bottom grid doesn’t filter. Should I be setting something up in the Properties, either using the Filter or Parameters tab please?

image
image1092×507 29.2 KB

Many thanks in advance!!

6

Are you refreshing after you select the filter?

7

Yeah tried that but turns out I’d added them as 2 separate queries so all sorted now! thanks

1 Like