O'Reilly logo

Oracle APEX 4.2 Reporting by Vishal Pathak

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Implementing soft deletion with AJAX and APEX templates

Soft deletion is done if we want to retain the record and the user wants to delete it. In soft deletion, when a delete operation is triggered on a table by the user, a flag is updated instead of deleting the record altogether. All queries on this table use the flag column to display only the records for which the flag has not been set. The query in the Slice & Dice region uses this flag ("OEHR_EMPLOYEES"."DELETE_FLAG" = 'N') to display only the records which have not been deleted by the user.

Let us now understand the process of creating a link on a column to soft delete a record. The AJAX emp delete column of the Slice & Dice region has <img src="#IMAGE_PREFIX#del.gif" alt="APP_PROC_DELETE"> ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required