BAQ dropdown in grid column not showing values

[Mathew (Mathew Willett)]

Hey all,

I’m attempting to add a BAQ DropDownList to a grid column, but am encountering a UI issue.

Here is the UI, where the Discount column is a BAQ dropdown. This grid loads collapsed, but when opened, no values are loaded even though there is data in the dataview:

And when the cell is clicked, I get the value to appear:

And the dropdown is working as expected and correctly binding:

Here is my Column setup for that field :

And here’s my Erp Editor Model :

Any help is greatly appreciated!

[tonyb1986 (Tony Burke)]

personally i can not, other than suggest have you seen this post?

Combo Boxes in App Studio

Documenting this here for future reference. To create a simple dropdown list, use a Combo Box. There are four types. Reusable (system list): set the following under Properties: Data > EpBinding = View.Column e.g. SearchFilters.ColumnName Reusable Combo > Type = ResourceGroup.ResourceGroupCombo (e.g.) Reusable Combo > Sub Type = default Advanced > Header = checked Hardcoded list : set the following under Properties: Data > EpBinding = View.Column e.g. SearchFilters.ProjectStatus Advanced > …

good luck and i hope you get sorted, i know how frustrating epicor can be with something so simple that should just work!!!

[Mathew (Mathew Willett)]

I checked that post out but it’s related to stand along combos instead of grid combos, and the differences between the two seem to matter…

The biggest issue I have is knowing if it’s my configuration that’s an issue or if it’s an Epicor bug. I want to give them the benefit of the doubt, but this one feels more bug-ish.

[tonyb1986 (Tony Burke)]

After the issues we found at the last update i would not be surprised, however i hope its not a bug and you do find a solution!

Sorry i am unable to help, i am on a steep learning curve in the Epicor world myself!

[dcamlin (David Camlin)]

I’m wondering if you might have better luck… instead of using a BAQ directly, have your BAQ populate a DataView and then drive your Combo off the dataview instead?

I’ve never done a grid combo, but I know other things seem to behave differently depending on whether it is DataView or BAQ populated. May have better luck?

[jwphillips (Jonathan Phillips)]

@Mathew

it’s related to stand along combos instead of grid combos, and the differences between the two seem to matter

That’s interesting. I have never made a BAQ combo … but the BO and regular list combos that I have made all function basically identically whether stand-alone or in a grid

[sameer (Sameer Desai)]

Just curious @Mathew, do you have ‘Auto Refresh Data on Load’ enabled? This ensures BAQ results load in the grid automatically on the initial load, without needing to click the refresh button. It might help populate the dropdown in your grid.

[Mathew (Mathew Willett)]

I tried that and still got the same result. Pesky thing…

[Mathew (Mathew Willett)]

Whelp, I ended up going in a different direction and used a BO service instead using this guide Combo Boxes in App Studio - #15 by LarsonSolutions.

Hopefully I can get this working some day…