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!

Conditional Default value/type for a form item

662805Aug 1 2009 — edited Aug 2 2009
Hi

I have a interactive report with a form on table 'A' which has 'who' columns like "CREATED_BY" , "LAST_UPDATED_BY". Now I was auto-populating these columns in the form with the &APP_USER. function. The scenario is when user 'P' clicks "CREATE" button on the report, these columns in the report get populated by P's info.After commiting this record, user 'Q' edit this same record with "Edit" link of this record. Both the columns get populated by Q's info, ideally only LAST_UPDATED_BY should get populaed by Q's info, and not the CREATED_BY column, as it is 'P' who created that record.

For that, I guess in the default value type for these items, I have to use "PL/SQL Function body" instead of "Static Text with Session State Substitutions". Problem is how to code the filter : whether the user pressed "create" button or the "edit" button. Please help

Thanks
Bhavesh
This post has been answered by ATD on Aug 1 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 30 2009
Added on Aug 1 2009
3 comments
837 views