Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » LOV return all value if null SELECTED (APEX4.0.2)
|
|
|
|
|
Re: LOV return all value if null SELECTED [message #651435 is a reply to message #651300] |
Tue, 17 May 2016 15:44  |
 |
Littlefoot
Messages: 21825 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Well, re-posting the original message doesn't help much. It appears that we don't understand each other.
It doesn't matter that the above query (which is, once again, most probably wrong as it doesn't join these 3 tables) does not return 1000 records but only 20. My reply would be the same if it returned only 2 records. So, if it is not a problem, imagine it returns two records. Where would you want to put those two (return) values? A LoV is attached to a single item, not to two (nor 20) of them. Therefore, it can select one value into one item. It can not put 2 values into 1 item unless you are satisfied with a solution which I described previously, using the shuttle item (I didn't try to select multiple values via a LoV): it enables you to select several values and put all of them into a single item. They are separated by a colon sign.
For example, if shuttle item shows this (display + return value in parenthesis):New York (1) --> you select this one,
London (2) --> this one and
Rome (3)
Zagreb (4) --> this one
The result - stored into an item - would be
Is this what you are looking for?
Or, would you like to populate (say) 20 rows in a tabular form with all values LoV's query returns? If so, that can be done using a loop and Apex array.
A simpler option would be to directly insert new records into an underlying table (using the SQL INSERT statement) and refreshing the layout.
Anyway: I still don't know what you are really trying to do. If possible, take a screenshot of that Apex page and describe what would you want to do with it.
|
|
|
Goto Forum:
Current Time: Wed Jul 09 19:32:09 CDT 2025
|