This content has been marked as final. Show 8 replies
Try this in your order by clause "order by 1 nulls last" where d is your display column.
Hi jrimblas , that didn't work. I guess that would work only with null values from the database table not from ApEx select list.
Edited by: Najla on Apr 1, 2013 10:45 PM
Edited by: Najla on Apr 1, 2013 10:46 PM
Did you try changing the property of the dropdown list. Change the Display Null value to "No".
Hope this helps.
Yes, I have a display value for it "Other".
I don't think it is possible to arrange the order of the null option in a select list.
One line of jQuery code fixes your issue though:
Replace "P10_ITEM" with the item name of your select list and make sure it executes on page load.
Sorry Nick, but I don't know what you mean by "#P10_ITEM option"
Edited by: Howard (... in Training) on Apr 2, 2013 1:xx PM
The statement -
I don't think it is possible to arrange the order of the null option in a select list.- is close. You can't control the order of the Null value if you add the Null value through the GUI. However, it can be added and controlled as part of a SELECT ...
One way is to add NULL to the "SELECT". Here the Yes/No are hard-coded but they could have been selected from a table:
select d, r from ( select 'YES' d, 'Y' r from dual union all select 'No' d, 'N' r from dual union all select Null d, '<Null>' r from dual ) order by 1 desc NULLS last
That's just a jQuery/CSS selector. It represents the first item in your select list which is in our case the null option.
In my example, the select list page item is called P10_ITEM. I use this page item name in my jQuery/CSS selector.
If, for example, your select list page item is called P175_SELECT_LIST, then the appropriate code would look like this: