OraFAQ Forum: Application Express, ORDS & MOD_PLSQL

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » About Apex collection (APEX 3.1.2)

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

About Apex collection [message #563222]

Fri, 10 August 2012 02:28

spatava
Messages: 12
Registered: April 2012
Location: Pune india

Junior Member

Hi,

I am using Oracle APEX 3.1.2.
I have created a report with 3 columns. For this I am using apex collection as shown in below query.

SELECT
   c004               original_file,
   apex_item.hidden(
      1,
      c001)   ||
   apex_item.hidden(
      4,
      seq_id) ||
   apex_item.popupkey_from_query(
      2,
      c002,
      'SELECT nvl(f.name,''No Name Specified'') ||'' - Pattern(/''  || f.pattern||  ''/)'' FROM mis_reporting.files f',
      50,
      100)            replace_by,
   nvl(c003, '&nbsp') errors
FROM   apex_collections
WHERE   collection_name = :P26_COLLECTION_NAME

It shows me corract report. After clicking on popup lov icon of second colunm, It takes me to popup window which having a text box and 2 button 'Search' and 'Close'. This window displays the list of values.

When I am tried to writing any pattarn into the text box and click on Search button. It gives me error as below:
'The page cannot be found'.

But If I mannuly select the report it works fine.
Could you please help me to sort out this issue.

Thanks in advance.
Suchita

[EDITED by LF: applied [code] tags]

[Updated on: Fri, 10 August 2012 06:15] by Moderator

Report message to a moderator

Re: About Apex collection [message #563242 is a reply to message #563222]

Fri, 10 August 2012 06:26

Littlefoot
Messages: 21759
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I never used that. However: LoV query *should* return two values: display value and return value. Your SELECT returns just one value. Is that OK?

Documentation suggests (note two returned columns - DNAME as "display" value and DEPTNO as "return" value):
Quote:

The following example demonstrates how to generate a popup select list from a SQL query.
SELECT APEX_ITEM.POPUPKEY_FROM_QUERY (1, deptno, 'SELECT dname, deptno FROM dept') dt 
FROM emp

So, if you just type something into a text item, that might be a "display" value while "return" value remained empty (NULL?).

[Updated on: Fri, 10 August 2012 06:27]

Report message to a moderator

Re: About Apex collection [message #563336 is a reply to message #563242]

Mon, 13 August 2012 01:08

spatava
Messages: 12
Registered: April 2012
Location: Pune india

Junior Member

Thanks a lot... It works...
In LOV query, display value and return value are must.

Thanks...
Suchita Smile

Report message to a moderator

Previous Topic:	Manually created tabular form - how to conditionally hide a checkbox in MSIE?
Next Topic:	misspelled column name

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 20 10:07:33 CDT 2023