Hi All,
I have created an Apex region having interactive report. The Source for this report is Database views that was created on top of Some tables.
My Requirement is to have an Editable Column in report (Say Column Name "User Comments") in form of Link when user will click on Add Comments link, it will open up a pop up window to add Comment (Restricted to 100 Characters only) against that record with Save Option.
Once user will save the comments, the Original interactive Report should be refreshed and updated comment should appear against that record in "User Comments" column.
and updated user comment should be saved in database to its Originating column of source table.
Please provide detailed steps as I am new to Oracle APEX world.