Skip to Main Content

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.

Get Display Value from Select list

user8041951Sep 9 2012 — edited Sep 11 2012
Hi,

I am using Apex 4.1 and I have a select list in my page. I know i can access the value of the selected item by :P1_SelectList, but I would like to know how to access the display value of the selected item.

Thanks in advance,
DS
This post has been answered by Hari_639 on Sep 11 2012
Jump to Answer

Comments

vinaykumar2
Answer

you can write in an el in the value of stauts field as "#{binding.status.inputValue=='A'?'Approved':'Rejected'}

Marked as Answer by Salman5 · Sep 27 2020
Antonis Antoniou

Hi,

Why don't you create another column that will hold the display values?

So your table is going to be like this:

     Column_A: A, X

     Column_B: Approved, Rejected

You can display on the UI Column_B while storing Column_A in the DB.

Even though what vinaykumar2 suggested will work i would personally avoid it as this requires hard-coding values on the UI.

Antonis

Salman5

Thank you vinaykumar2,

What if there is more options other than Approved and Rejected conditions, how can I specify that in the Expression Language. some thing like:

if 'A' then Approved

else if 'X' then Rejected

else if 'C' Canceled

else if 'R' then Reviewed

else if .....

my point is there is many conditions.

Salman5

I found the answer for nested condition in Expression Language in this thread:

vinaykumar2

good..

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

Post Details

Locked on Oct 9 2012
Added on Sep 9 2012
6 comments
16,427 views