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!

Set default value on LOV if only 1 row returned

AnnelizeFSep 20 2017 — edited Sep 21 2017

I'm using Apex 5.1

I wondered if there is a way to set the default of a dropdown list if only one row is returned by the LOV to the one value that is returned?

I have demonstrated what I'm trying to achieve on apex.oracle on the page 'Default Dropdown'

Have a look at my workspace: AF_PLAY with the same login credentials. Application: Play, Page 7

I have created an LOV for DEPTNO and restricted the query to DEPTNO=10 for demonstration purposes.

If there is only one value in that dropdown, how would I go about setting that as the default? I do not want to set' Display Null Value' to 'No' as this will always set the value to the first in the list even if there are more than one in the LOV.

Thanks for your help

Annelize

This post has been answered by LA County APEX on Sep 20 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 19 2017

Added on Sep 20 2017

#apex-discussions, #lov

2 comments

758 views