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!

Add a text box to Interactive report in APEX 4.2

alicegOct 16 2015 — edited Oct 22 2015

I built an IR a while ago as part of one APEX application for one of our departments.

The users recently asked for a field to be added where they can insert a date when a specific task has been performed.

However, they want to perform this globally rather than navigate from IR to a specific record, put the date and come back.

I really need a hybrid IR, where all columns are read only, just this new column (date)which I am planning to add to the underlying table needs to be editable and a Dynamic action will be called to update the table with the last entered value. (I was able to accomplish something similar with a dynamic action for a text box where user can modify and then when she exists the field, the latest value appears).

I don't want to change the whole query and use collection for just one single editable field.

I read one post where 'an out of the box' solution might be available.

I know there are many ways to accomplish this, but I am looking for the most elegant, straightforward solution, which makes full use of existing functionality in APEX.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 19 2015
Added on Oct 16 2015
5 comments
3,361 views