BAQ combo box in Application Studio

sameer · January 15, 2025, 3:53pm

I have Kinetic Application dashboard which shows 4 columns:

It uses a BAQ to get these fields from UD23 table.

I am trying to add a combo box dropdown that searches by Product Code. I want the values in the dropdown to be from BAQ: CTC-HTS-ProdCode-Dropdown which gives this as result:

For now I just want dropdown text and value to be from Product_Code column.
Currently, I tried this to use BAQ result in combo box but it is not working. Combo box is not clickable.

How do I debug this approach? Or should I switch to using a DataView instead?

cory.davis · January 15, 2025, 4:03pm

What do you have in the EPBinding under the Data section for that combo box? If there’s nothing there the control won’t be clickable

sameer · January 15, 2025, 4:18pm

Ok, yes I had EpBinding as empty. I just put in the main DataView of the 4column table with the Key1 which is the Product Code column because that is what I want to filter by. This made it clickable

But now if I choose a Product Code from dropdown, it is not filtering. Do I need to add a value in EpBinding Text Column?

Sorry this is first time I am using Application Studio.

cory.davis · January 15, 2025, 4:43pm

I would recommend setting the epbinding to a transview field (you will have to create the transview dataview if this is a custom dashboard) then set your grid filter so that key1 column from your baq is equal to the transview column.

sameer · January 15, 2025, 4:46pm

TransView and CTCtestHTScodes_0_0 were auto populated when I created dashboard.

Can I just use the CTCtestHTScodes_0_0 DataView as that is what the main table is which I want filtered?

sameer · January 15, 2025, 4:53pm

Would it be here in the grid properties that I put filter where the grid column Product Code equals the Product Code selected in dropdown somehow?

sameer · January 21, 2025, 4:18pm

"I solved this by creating a DataView for the Product Code dropdown, which pulled its data from a BAQ. In the main grid, I used the dropdown’s value in the DataView to filter results via BAQ Options > Where List. Getting the correct syntax for the Value section took some trial and error. I referenced: How To: Kinetic BAQ Grid Pub-Sub - #5 by cschrempp