Reusable Combo Box in BAQ option where list

Kinetic ERP
1

I have a simple dashboard I created in Application Studio that pull in labor details. The user needs to enter a date range and employee. The employee field is a reusable combo box using EmpBasic.EmpBasicCombo. The date range part seems to be working correctly. My problem comes with the employee field. I created the field.

image
image431Ă—897 11 KB

I have the initialized it.

image
image425Ă—515 5.81 KB

I add the BAQ where clause.

image
image444Ă—775 11.9 KB

When I preview the dashboard, the date range fields work. There is a drop down for the employee selection, but when one is selected, the dashboard grid shows blank. I am hoping I am just missing something simple, but I can’t see what it is. I can get it working with a text box that the user has to enter the employee’s name, but would rather it be a drop down where the name is selected.

2

Open the network tab and look at the call when it tries to run the baq. The preview has the execution options, and it probably doesn’t have what you’d expect.

3

I don’t know what you mean when you say to open the network tab. Can you tell me how to do that?

4

Press F12. It will open Dev-Tools.

Poke around!

Welcome to the world of Kinetic debugging.

5

Perhaps your combo is displaying name but the bound value is EmpID. What do you see in the TransView field?

6

I thought of that. It is the name field.

7

Josh,

I think you are correct. I just tried it again and it seems to be working with the employee id. I think I had omitted the single quotes on the BAQ where clause before which was the reason it did not work for me when I intially tried it. Thanks so much. This is the last of my Classic dashboards and customizations that I needed to convert.