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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Processing
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,942 views