OraFAQ Forum: Application Express, ORDS & MOD_PLSQL

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » list of value items POP UP (4.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

list of value items POP UP [message #550700]

Wed, 11 April 2012 13:24

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?

Report message to a moderator

Re: list of value items POP UP [message #550705 is a reply to message #550700]

Wed, 11 April 2012 14:06

Littlefoot
Messages: 21761
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

Report message to a moderator

Re: list of value items POP UP [message #550708 is a reply to message #550705]

Wed, 11 April 2012 14:14

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?

Report message to a moderator

Re: list of value items POP UP [message #550709 is a reply to message #550708]

Wed, 11 April 2012 14:17

Littlefoot
Messages: 21761
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?

Report message to a moderator

Re: list of value items POP UP [message #550710 is a reply to message #550709]

Wed, 11 April 2012 14:18

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!

Report message to a moderator

Re: list of value items POP UP [message #550711 is a reply to message #550710]

Wed, 11 April 2012 14:19

newprogrammerSQ
Messages: 48
Registered: April 2012

Member

I did check some tutorials however I don't understand how the ||'s etc work...

Report message to a moderator

Re: list of value items POP UP [message #550712 is a reply to message #550711]

Wed, 11 April 2012 14:22

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?

Report message to a moderator

Re: list of value items POP UP [message #550713 is a reply to message #550711]

Wed, 11 April 2012 14:24

Littlefoot
Messages: 21761
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.

Report message to a moderator

Re: list of value items POP UP [message #550714 is a reply to message #550712]

Wed, 11 April 2012 14:25

Littlefoot
Messages: 21761
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.

Report message to a moderator

Re: list of value items POP UP [message #550715 is a reply to message #550714]

Wed, 11 April 2012 14:35

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

Report message to a moderator

Re: list of value items POP UP [message #550716 is a reply to message #550715]

Wed, 11 April 2012 14:41

Littlefoot
Messages: 21761
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.

Report message to a moderator

Previous Topic:	reports and LIST OF VALUES items APEX
Next Topic:	Log in page on APEX

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Mar 31 13:29:48 CDT 2023