Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle APEX_ITEM for Non Database Table Columns - User Entered

Tony FatourosAug 21 2012 — edited Aug 26 2012
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 23 2012
Added on Aug 21 2012
2 comments
541 views