Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Multi column LOV in Apex (Oeacle Apex 4.0)
Multi column LOV in Apex [message #461798] |
Mon, 21 June 2010 09:17  |
Its_me_ved
Messages: 979 Registered: October 2009 Location: India
|
Senior Member |
|
|
In apex, we can create a single value LOV. Is there a way to create multi column LOV?
Well, I have got a link where this is done by using Ajax, jQuery.
But as I am a beginner in Apex as well it quite a complex one for me. If anyone here solved this problem.
A demonstration will help me a lot
Regards
Ved
|
|
|
|
|
|
|
|
Re: Multi column LOV in Apex [message #462353 is a reply to message #462331] |
Wed, 23 June 2010 12:08   |
 |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
How would that "multi column list of values" look like?
As far as I know, an Apex LoV contains two values: a display and a return value. A return value is what you use. A display value is what you see.
So, if you'd only want to see more than a single value when a LoV is displayed, you'll need to "fool" Apex so that it returns a single value, but that it consist of several values. How to do that? Using concatenation.
Here is an example; I don't know is that what you are looking for, but there's nothing else I can say. This list of values returns information about a car:
The original query A modified query
---------------------------- -------------------------------------------------
select car_name display_val, select car_name ||' / '||
car_id return_val to_char(sysdate, 'dd.mm.yyyy') ||' / '||
from cars 'some value' display_val,
order by 2 desc car_id return_val
from cars
order by 2 desc
The result, when a LoV is selected is as follows:

Obviously, these are not "real" columns, but - if it suits your needs - use it.
I guess that's all I meant to say.
-
Attachment: apex_lov.PNG
(Size: 4.17KB, Downloaded 4992 times)
|
|
|
|
|
Goto Forum:
Current Time: Sun May 04 21:54:03 CDT 2025
|