| LOV return all value if null SELECTED [message #651246] |
Fri, 13 May 2016 09:35  |
 |
pcouas
Messages: 112
Registered: February 2016
|
Senior Member |
|
|
Hi,
Currently i have an LOV component like this
SELECT grp.TEU_GROUP_NAME display_value,
grp.TEU_GROUP_UID return_value
FROM LO_TEU_GROUP grp,
lo_vessel ve,
lo_teu teu
Then i have define in APEX defined
Null Display Value ALL Null Return Value ALL
So could i modify Query or APEX page for returning all LISTBOX values if null or ALL is selected ?
Regards
Phil
|
|
|
|
|
|
|
|
|
|
|
|
| Re: LOV return all value if null SELECTED [message #651435 is a reply to message #651300] |
Tue, 17 May 2016 15:44  |
 |
Littlefoot
Messages: 21823
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
