Multi column LOV in Apex [message #461798] |
Mon, 21 June 2010 09:17 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #462331 is a reply to message #462287] |
Wed, 23 June 2010 09:44 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Its_me_ved
Messages: 979 Registered: October 2009 Location: India
|
Senior Member |
|
|
Yes, I talked about that link. As I am a beginner in AJAX I asked for some alternative way instead of going for some complex code that I dont know.
I simply want to know If there is any solution using javascript or is there a way in apex itself.
Thanks
Ved
|
|
|
Re: Multi column LOV in Apex [message #462353 is a reply to message #462331] |
Wed, 23 June 2010 12:08 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 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:
![/forum/fa/7926/0/](/forum/fa/7926/0/)
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 4865 times)
|
|
|
Re: Multi column LOV in Apex [message #462396 is a reply to message #462353] |
Thu, 24 June 2010 01:10 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Its_me_ved
Messages: 979 Registered: October 2009 Location: India
|
Senior Member |
|
|
Quote:
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:
Please have a look at the link provided by Sriram (ramoradba).
You can see a demonstration there (one similar to multi column LOV
in Oracle Forms.I believe you know that well.)
But as I am a beginner in ajax, jquery it would be too fast to work
with such complex code.
Therefore I asked if there is any alternative solution there using javascript.
I already mentioned that we can create a single value LOV in apex.
Hope you understand.
Regards
Ved
|
|
|
|