In the valuelist definition dialog, you have the option of specifying the sort order.
We noticed two bugs related to this ability when defining a valuelist based on a relation:
A) You can specify non-related sort columns, resulting in a developper freeze when you return in the dialog from the sort selection window. In that case you have to force quit developper and start again.
B) Related valuelist is automatically sorted ascending by the colums shown in dataprovider. However, if you try to add your personnal sort, the resulting query to sql becomes erroneous (-> ASA), see the trace below.
stacktrace without sort:
used sql select distinct f0001,f0020,f0018 from rEmployees where rEmployees.f0001 != ? and rEmployees.f0008 is null order by f0020,f0018 questiondata.lenght 2questiondata[0]= 11 ,type: java.lang.Integer
questiondata[1]= null
stacktrace with sort added:
used sql select rEmployees.f0001, rEmployees.f0002, rEmployees.f0003, rEmployees.f0004, rEmployees.f0005, rEmployees.f0006, rEmployees.f0007, rEmployees.f0008, rEmployees.f0009, rEmployees.f0010, rEmployees.f0011, rEmployees.f0012, rEmployees.f0013, rEmployees.f0014, rEmployees.f0015, rEmployees.f0016, rEmployees.f0017, rEmployees.f0018, rEmployees.f0019, rEmployees.f0020, rEmployees.f0021, rEmployees.f0022, rEmployees.f0023, rEmployees.f0024, rEmployees.f0025, rEmployees.f0026, rEmployees.f0027, rEmployees.f0028, rEmployees.f0029, rEmployees.f0030, rEmployees.f0031, rEmployees.f0032, rEmployees.f0033, rEmployees.f0034, rEmployees.f0035, rEmployees.f0036, rEmployees.f0037, rEmployees.f0038, rEmployees.f0039, rEmployees.f0040, rEmployees.f0041, rEmployees.f0042, rEmployees.f0043, rEmployees.f0044, rEmployees.f0045, rEmployees.f0046, rEmployees.f0047, rEmployees.f0048, rEmployees.f0049, rEmployees.f0050, rEmployees.f0051 from rEmployees where rEmployees.f0001 != ? and rEmployees.f0008 is null and rEmployees.f0001 != rEmployees.f0001 and ? = rEmployees.f0008 order by rEmployees.f0020, rEmployees.f0018 questiondata.lenght 2
questiondata[0]= 1 ,type: java.lang.Integer
questiondata[1]= null