Oracle APEX_ITEM for Non Database Table Columns - User Entered
Hi,
Hoping someone can assist me with how to use APEX_ITEM.text for where the source for this comes from user input values and not for an underlying table.
I have a report where three columns are coming from an actual table (one being a checkbox for selection) but then also have two additional fields on the screen that are not from a table but placeholder fields for user's to enter data.
For example, my query looks like this:
select apex_item.checkbox2(10,id),
name,
telephone,
apex_item.text(20,NULL) as "Date Contacted",
apex_item.textarea(30,NULL,5,80) as "Comment"
from my_table
Is this the correct way to achieve what I am after as from the looks of it, I am not seeing any values for the two user fields when entering values and doing a view source?
Would appreciate your help with this.
Thanks.
Tony.