Combo box usage in Kinetic

[Ignacio (Nacho)]

Greetings.

I want to ask if it is possible to feed a combo box through a BAQ or from SQL.

I would like to know if there are other ways to use the combo box in kinetic or can it only be fed through the user codes module?

Thanks.

[hmwillett (Hannah Willett)]

You can do a BAQ or manually entered items alongside the BOs.
No direct SQL.

[Ignacio (Nacho)]

It is not clear to me how to do that.

Could you show me an example or guide me with the steps.

Regards

[hmwillett (Hannah Willett)]

Just enter the query ID in the box that says “Query ID”.

[hmwillett (Hannah Willett)]

[Ignacio (Nacho)]

Thank you very much for your support

I followed the steps and got the following result:

Test BAQ:

Combo box configuration:

The combo box is shown disabled:

[hmwillett (Hannah Willett)]

Did you bind it to anything? EpBinding.

[Ignacio (Nacho)]

No, I will put a transview

[Ignacio (Nacho)]

Do two tests with the following information:

The result is as follows:

The query does return rows:

[hmwillett (Hannah Willett)]

Check Dev Tools to check for errors.

[Ignacio (Nacho)]

Attached is a screenshot:

Anything specific that I can show?

[hmwillett (Hannah Willett)]

You should see an ExecuteByID call in there. Did you click on your drop down?

[Ignacio (Nacho)]

Result:

[hmwillett (Hannah Willett)]

Do as it says.
“Bad SQL statement. Check the server logs for details.”

[Ignacio (Nacho)]

Sorry
I did some tests, but I couldn’t find how to do that.

[hmwillett (Hannah Willett)]

Log into the server and open the event viewer. You will see an error logged in there.

[Ignacio (Nacho)]

Could be this message:

[hmwillett (Hannah Willett)]

Get rid of the data mode: list and see if that helps.

[Ignacio (Nacho)]

A new BAQ is created:

The correct result is successful:

[hmwillett (Hannah Willett)]