Kinetic Dashboard - populate combobox with BAQ field

Hi All,

I am trying to get a combobox to populate with the data from a column in a BAQ so that the result can be used to filter, but when I preview the dashboard the combobox is disabled which I presume it means it’s not being populated
This is the setup I currently have

Thanks

Steve

Hey Steve, what you filled out looks good. Did you also make sure to enter a value in the EpBinding field? That’s usually the culprit when a control is disabled.

Hi Vicken

Yes I did, figured out why it was disabled, didn’t have “Key Field” ticked
How ever the combo is still not populating
The BAQ used to popluate it is the same as the one used for the dashboard, do I need to trigger the BAQ on Create to get it populate?

Thanks

Steve

I recommend debugging this with the DevTools (Network tab). The first time you click the Combo Box’s down arrow, it should call ExecuteByID. If you don’t see that call, it’s likely a binding issue. Be careful when binding to TransView, you’ll need to initialize it yourself if it’s a custom App.

You can plug with BAQ parameters and wire your filter as a combo box with another BAQ.

Hi Steve,

Selecting the “Key Field” setting technically will enable the control… but you NEED a binding.

With Binding instead of Key Field:

“Key Field”, yes, will set the control to enabled by default… but this setting is primarily supposed to be used for key identifying columns in a dataview that identify the row/record. Part.PartNum for example.

A combobox NEEDs a binding. It is programmed to store a value (the value selected by the user). If you don’t have a binding, it doesn’t have anywhere to store their selection.

Unless I am misunderstanding I have had better luck using a reusable combo and calling the BAQ service

Yeah, I’ve done that too… but even outside of setting up the combo using a BAQ… even a stock re-useable combo will fail if it doesn’t have a binding:

Without Binding:

With Binding:

Thanks David, that’s really helpful