Combobox connector select column for value

Suite and Optimus Suite 5
#1

When populating my combobox I need to select which column from the table should populate the value attribute in the input element.

I looked through the documentation and this is what I found
docs.dhtmlx.com/connector__java_ … datafromdb

Didn’t work for me. Am I doing it wrong?
This is the query I used for it, it does populate the combobox with the names but it doesn’t work for value.

render_sql("select distinct adressName as value from adresses where deleted=0", "adressId", "adressName(value)")
#2

You are using adressId as id value, but it is not selected from DB ( SQL code doesn’t select such field from DB )