I am new to Apex development. I create an app to display a list of available reports. I want the user to highlight a report from a list of values and click on it. Once clicked I want to display all the reports parameters so that the user can chose how to run the report and then click a button that says "View Report". The main region has a sub region of type "Classic Report" where I want to utilize the apex_item pkg to display the report parameter name and display "Date Picker" or "Select List" for each parameter. This is the SQL Query I'm using. The problem is the Date Picker or Select List displays html instead of the GUI I would expect. Can anyone point me in the right direction as to where to trouble shoot?
select display_sequence,
label,
decode(display_as,
'Date Picker',
apex_item.date_popup2(
p_idx => 1,
p_value => nvl(apex_util.get_preference (p_preference => 'item ' || item_id || ' last_value'),
item_default
),
p_date_format => format_mask,
p_attributes => 'placeholder="' || placeholder|| '"',
p_item_label => label),
'Select List',
apex_item.POPUP_FROM_LOV (
p_idx => 1,
p_lov_name => lov_named_lov/*,
p_show_null => lov_display_null,
p_null_value => lov_null_value,
p_null_text => lov_null_text,
p_show_extra => lov_display_extra*/),
/*
apex_item.select_list_from_lov_xl(
p_idx => 1,
p_lov => lov_named_lov,
p_show_null => lov_display_null,
p_null_value => lov_null_value,
p_null_text => lov_null_text,
p_show_extra => lov_display_extra),
*/
apex_item.text(
p_idx => 1,
p_value => nvl(apex_util.get_preference (p_preference => 'item ' || item_id || ' last_value'),
item_default
),
p_attributes => 'placeholder="' || placeholder|| '"',
p_item_label => label || ' ')
) item
from apex_application_page_items
where application_id = :APP_ID
and page_id = :P1_GOTO_REPORT
and display_as != 'Hidden'
order by display_sequence
the output I see on the screen should be a Date Picker but I get this instead. You can see the display_sequence, label columns. The display_as column is hidden. I don't know why "Label" is showing as html instead of a gui date picker? Any help appriciated.
10 Enter Creation Date From <label for="apex_date_01_00" class="u-VisuallyHidden">Enter Creation Date From</label><span style="white-space: nowrap;"><input type="text" placeholder="DD-MON-RRRR" id="apex_date_01_00" name="f01" maxlength="2000" size="20" value="" autocomplete="off"></span>