Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Multiple column in LOV

926190Mar 25 2012 — edited Oct 15 2013
Dear 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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 12 2013
Added on Mar 25 2012
#apex, #apex-discussions, #list, #lov, #select
7 comments
5,963 views