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.
Hi everyone,
I created select list with the data I have. But, i get two empty rows (selection) before the actual names i want to get shown. Can anyone help me with it, please?
The screenshots are for to clarify my question.
Thanks for any help!
-R.E
helpme_helpyou wrote:I created select list with the data I have. But, i get two empty rows (selection) before the actual names i want to get shown. Can anyone help me with it, please?
helpme_helpyou wrote:
What are the settings for the Display Extra Values and Display Null Values properties on the select list item? (Read the online help for these properties while you're there).
They were YES, but I just changed them to NO. Even tho, i still have one empty selection. (one of them removed already and thanks for helping)
helpme_helpyou wrote:They were YES, but I just changed them to NO. Even tho, i still have one empty selection. (one of them removed already and thanks for helping)
So what's in the data? Run the LOV query in SQL Workshop.
how can i do that? i have never done that and i am new on APEX.
thanks for your help!
helpme_helpyou wrote:how can i do that? i have never done that and i am new on APEX.
Thanks for the steps! I got four rows which includes one extra (empty row). How can i avoid that one? Please, see the following screenshot for the results.
I found the problem. I added additional column without putting Location type into it. I think it causes it to show one empty selection.
Thanks for helping
helpme_helpyou wrote:Thanks for the steps! I got four rows which includes one extra (empty row). How can i avoid that one?
Thanks for the steps! I got four rows which includes one extra (empty row). How can i avoid that one?
I have no idea because I have no knowledge of the data model. However, the LOV query indicates that the data model is not properly normalized, providing further evidence that it is probably wrong.
i found the problem. It should be there (the one of the empty selection), because the user also may choose nothing for that which required empty selection. can you please help me with another question which i just shared 5-10 mins ago? thanks again for helping!
