Multiple column in LOV
926190Mar 25 2012 — edited Oct 15 2013Dear community,
I have been struggling with the issue that Apex wont allow me to display more than 1 value/column in a LOV/select-list.
Is there a fix or workaround for that? I have been searching all over the internet, landed on a webpage with jQuery but I have no idea how to execute since I am a beginner at apex.
Situation:
I have a table with students containing columns: studentnumber, name, lastname.
I want to create a LOV displaying all the 3 columns and return with studentnumber.
what I tried in sql:
select studentnumber, name, lastname as display_value, studentnumber as return_value
from students
order by 1
But failed since you can give only 1 value @ display_value ( I gave 3 ).
Thanks!
Edited by: 923187 on 25-mrt-2012 7:53