cancel
Showing results for 
Search instead for 
Did you mean: 

Populating a combo box on a form?

Former Member
0 Kudos

Hi All

I am new to visual composer but I am managing to get the hang of it quite quickly. However I have hit a problem which I want to know how to solve, hope someone can help!

I have a form which has a combo box which I want to populate with data from a SQL table. So when they open the page the combo box is already populated.

Hope this makes sense?

Thanks all for your help!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi, Phil!

Dynamic entry list might be the key. For example if source system is bw, then one can connect drop-dowm list, etc. to actual data via dynamic entry list.

So if you use stored procedure in sql, then I think you should be able to use dynamic entry list to get the job done.

Hope it'll help.

--- Kaspars

Former Member
0 Kudos

Yeah thanks - I am actually just using a sql table.

I have put in an Entry List but I cannot get this to work at runtime. Everytime the iview opens the combo box is empty!!!!

former_member188977
Contributor
0 Kudos

Hi Phil,

You can use a "Drop-down list" component.

In Entry list select your BI_JDBC System and search the specific table that you want to retrive the values.

In the next steap you can leave blank the selections in input port and set TEXT and VALUE of output port with the field that you need.

Regards,

Nacho.

Answers (0)