Picking out other columns in Custom Valuelist Code?

Classic Servoy
1

Hi Folks

I’m using a custom valulist to populate a combo box on a form:

var maxRows = 1000
var globData = 1;
var query = ‘SELECT * FROM data_dictionary WHERE dd_show_in_global_data_change = ?’;
var args = new Array();
args[0] = globData;
var dataset = databaseManager.getDataSetByQuery(controller.getServerName(), query, args,maxRows);
var saveArray = dataset.getColumnAsArray(3);
var displayArray = dataset.getColumnAsArray(7);
application.setValueListItems(‘vlt_cols_to_update_global_data_mod’,displayArray, saveArray);

2

Hi Ian,
where is your question hidden? :wink:

3

Maybe I got it… try something like this:

var maxRows = 1000
var globData = 1;
var query = "SELECT pk, col1||', '||col2||' ('||col3||')' FROM data_dictionary WHERE dd_show_in_global_data_change = ?"; 
var args = new Array();
args[0] = globData;
var dataset = databaseManager.getDataSetByQuery(controller.getServerName(), query, args,maxRows);
var saveArray = dataset.getColumnAsArray(1);
var displayArray = dataset.getColumnAsArray(2);
application.setValueListItems('vlt_cols_to_update_global_data_mod',displayArray, saveArray);

That should return a string for display value like: “MyColumn1Value, MyColumn2Value (MyColumn3Value)” and save the pk in the database.
Do I win something? :)

4

mboegem:
Hi Ian,
where is your question hidden? :wink:

Sorry Marc I was developing the post and had a power failure (UPS did’nt take the strain LOL) and I thought it had’nt posted - sorry Bud.

I found my way around the problem anyways !

Thanks Marc / Nicola LOL :oops:

5

No problem but… do I win something? :D

6

ngervasi:
No problem but… do I win something? :D

Err… yes!