This discussion is archived
2 Replies Latest reply: Jan 31, 2013 1:46 AM by 911327 RSS

APEX_LIST.SELECT_ITEM() issue

969095 Newbie
Currently Being Moderated
Hi all,

I'm new to Apex.

I'm having a problem when I want to download a CSV report from an interactive report, the thing here is that the interactive report has this SQL query code in its region source:
select 
APEX_ITEM.SELECT_LIST(1,'Y','Yes;Y,No;N') "Type",
"ID", 
"ID_CATEGORY",
"NAME"
FROM "#OWNER#"."CATEGORY" 
when the CSV file is displayed, it just comes blank, no information in it, I've been digging and found that the APEX_LIST.SELECT_LIST is making some sort of error that prevents the data to be displayed.

In Report attributes, under column attributes, I have these columns: ID (NUMBER) (HIDDEN); ID_CATEGORY (NUMBER) (Display as text, escape special characters); NAME (STRING) (Display as text, escape special characters); TYPE (STRING) (Standard Report Column).

when I make further research i found that the list only returns this code for each row in the table:
<select name="f01" ><option value="Y" selected="selected">Yes</option><option value="N" >No</option></select>
It seems that is not getting the returning values of the select list, should I make an item to store this values?, please help is pretty urgent.

running on Apex 4.1.1.00.23, don't know which oracle DB is running, I believe is 11g

Thanks in advance,
  • 1. Re: APEX_LIST.SELECT_ITEM() issue
    714270 Pro
    Currently Being Moderated
    Hi,

    I do not see a problem with your query; not sure why the csv is coming blank. Can you make sure that the "Report Columns" region under "Report Print Attributes" (right click the report and select Print Attributes) has your columns with "Show in Report" set to "Yes". The hidden columns would obviously appear "Show in Report" set to "No".


    Thanks,
    Rohit
  • 2. Re: APEX_LIST.SELECT_ITEM() issue
    911327 Newbie
    Currently Being Moderated
    Hi , i want to add values to a select list, every month i want to add mm/yyyy for the current month and year, but how can i do it not manually? anyone can help me?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points