Home » Developer & Programmer » Application Express & MOD_PLSQL » list of value items POP UP (4.0)
list of value items POP UP [message #550700] Wed, 11 April 2012 13:24 Go to next message
newprogrammerSQ
Messages: 48
Registered: April 2012
Member
is it possible to add more data on the POPUP LIST OF VALues?

at the moment list comes up showing ID... is it possible to inlcude CUSTOMER NAME, and other fields enxt to the ID? but not affecting the link when it is clicked the textbox is only filled with the ID?
Re: list of value items POP UP [message #550705 is a reply to message #550700] Wed, 11 April 2012 14:06 Go to previous messageGo to next message
Littlefoot
Messages: 19335
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As LoV requires exactly 2 values: display & return, it is possible to show several values into DISPLAY using a concatenation operator. For example:
select ename ||', '|| job ||', '|| sal display_value,
       empno return_value
from emp
Re: list of value items POP UP [message #550708 is a reply to message #550705] Wed, 11 April 2012 14:14 Go to previous messageGo to next message
newprogrammerSQ
Messages: 48
Registered: April 2012
Member
hi thanks for reply... where do i edit the code?

currently it is :


select CUSTOMER_ID display_value, CUSTOMER_ID return_value
from Customer
order by 1


I want to include CUSTOMER_NAME and CUSTOMER_JOB to be included only in the display?
Re: list of value items POP UP [message #550709 is a reply to message #550708] Wed, 11 April 2012 14:17 Go to previous messageGo to next message
Littlefoot
Messages: 19335
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How do you mean, "where do you edit the code"? Is it not obvious from my example?
Re: list of value items POP UP [message #550710 is a reply to message #550709] Wed, 11 April 2012 14:18 Go to previous messageGo to next message
newprogrammerSQ
Messages: 48
Registered: April 2012
Member
nope sorry Im not an expert in this... ename is the default? should I replace that with CUSTOMER_ID? sorry!
Re: list of value items POP UP [message #550711 is a reply to message #550710] Wed, 11 April 2012 14:19 Go to previous messageGo to next message
newprogrammerSQ
Messages: 48
Registered: April 2012
Member
I did check some tutorials however I don't understand how the ||'s etc work...
Re: list of value items POP UP [message #550712 is a reply to message #550711] Wed, 11 April 2012 14:22 Go to previous messageGo to next message
newprogrammerSQ
Messages: 48
Registered: April 2012
Member
Hi just messed with it and got it showing more info however on selecting it. it puts the additional info into the textbox.... I only want the ID in the textbox?
Re: list of value items POP UP [message #550713 is a reply to message #550711] Wed, 11 April 2012 14:24 Go to previous messageGo to next message
Littlefoot
Messages: 19335
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
select customer_id ||', '|| customer_name ||', '|| customer_job display_value,
       customer_id return_value
from customer
order by customer_id

Perhaps you should get familiar with basic SQL. Consult SQL Reference book.
Re: list of value items POP UP [message #550714 is a reply to message #550712] Wed, 11 April 2012 14:25 Go to previous messageGo to next message
Littlefoot
Messages: 19335
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
newprogrammerSQ wrote on Wed, 11 April 2012 21:22
Hi just messed with it and got it showing more info however on selecting it. it puts the additional info into the textbox.... I only want the ID in the textbox?

That's how it works. You don't see RETURN value, but everything you put into a DISPLAY value is, well, displayed.
Re: list of value items POP UP [message #550715 is a reply to message #550714] Wed, 11 April 2012 14:35 Go to previous messageGo to next message
newprogrammerSQ
Messages: 48
Registered: April 2012
Member
Hi thank you very much for your help... Are you online often? over the next week I will be finalising my application by adding charts etc and that I may need help on ... are you any good with sql behind charts or is there a topic set up regarding this??

thanks in advanced
Re: list of value items POP UP [message #550716 is a reply to message #550715] Wed, 11 April 2012 14:41 Go to previous message
Littlefoot
Messages: 19335
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Feel free to ask any question; hopefully, someone will assist.

Note that Apex contains rather good online help. Almost all properties, when clicked on their name, have a short description. There are also syntax examples provided when necessary. Don't be afraid to click on these links and read what's being said.
Previous Topic: reports and LIST OF VALUES items APEX
Next Topic: Log in page on APEX
Goto Forum:
  


Current Time: Wed Jul 30 13:27:59 CDT 2014

Total time taken to generate the page: 0.12472 seconds