Home » Developer & Programmer » Application Express & MOD_PLSQL » About Apex collection (APEX 3.1.2)
About Apex collection [message #563222] Fri, 10 August 2012 02:28 Go to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 19610
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 Go to previous message
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
Previous Topic: Manually created tabular form - how to conditionally hide a checkbox in MSIE?
Next Topic: misspelled column name
Goto Forum:
  


Current Time: Thu Sep 18 13:46:17 CDT 2014

Total time taken to generate the page: 0.10054 seconds