Select list display issue

Question

Good morning, within Oracle Apex Application Builder I'm trying to create a order product page which displays products from a product table, shows a select list which a user can use to define the quantity in which they want to order. Using a classic report to display my code, the declared table columns were generated and outputted on the report, however the select list column only shows the html syntax used to create a select list and not the actual drop down select list with values.

Here is the code:

select p.product_id, 
   p.product_name, 
   p.product_price, 
   apex_item.hidden(1, p.product_id) ||
      apex_item.hidden(2, p.product_price) || 
      apex_item.select_list(
          p_idx           =>   3,
          p_value         =>   nvl(c.c003,'Add_to_cart'),
          p_list_values   =>   '1,2,3,4,5,6,7,8,9,10',
          p_show_null     =>   'YES',
          p_null_value    =>   0,
          p_null_text     =>   '0',
          p_item_id       =>   'f03_#ROWNUM#',
          p_item_label    =>   'f03_#ROWNUM#',
          p_show_extra    =>   'NO') "add_to_cart"
from prod p, apex_collections c
WHERE c.collection_name (+) = 'ORDER_ITEMS'
and c.c001 (+) = p.product_id

Can someone explain why this is happening, how to correct my issue and if there are better ways to implement a select list; as I need this code to work for my project?

Thanks in-advance for the help!

Littlefoot Littlefoot · Accepted Answer · 2018-03-21T09:57:13

In Builder, navigate to that column so that you'd see its properties. Scroll down to Escape special characters and set it to "No". Then run the report and see whether there's any improvement (should be).

Select list display issue

1 Answers