Skip to Main Content
Feature Request FR-4022
Product Area APIs
Status CLOSED

1 Voters

Plugin - Log change history in Forms

p.paul Public · Sep 25 2024

Idea Summary
Plugin - Log change history in Forms 

Use Case
Who changed what, record change history is required in almost all scenarios. 

Preferred Solution (Optional)

A plugin to capture the record changes along with timestamp and user name. [This can be a save trigger or  it can be added to as a dynamic action] 

  • Log information
  • Original data &  New Data [Only changed data] in Json or any other format 
  • User id 
  • System date time stamp 
  • App id / Page id / Block name 
  • Log table can be a generic table, where history info can be checked/reviewed.
We reviewed this idea carefully, and while it was interesting, we concluded that due to all the internal implications we need to take into account, it is unlikely to make its way into APEX.

Comments

Comments

  • jayson hanes Admin OP 1.7 years ago

    hi @p.paul these are all database features that are already possible with triggers or database auditing - https://www.oracle.com/database/technologies/security/db-auditing.html

    Mind you, the details of logging the APEX app id / Page id etc wouldn't be handled with this as you ask..

  • p.paul OP 1.7 years ago

    Hi @jayson hanes , 

    Thanks for the tip  as you said it can be handled at the db. level 

    I am also curious to know if there is any inbuilt feature to implement the 4 eyes principle (input and authorize).

  • jayson hanes Admin OP 1.7 years ago

    APEX supports declarative Authorization Scheme configurations as well as low-code and even high-code authorizations that can be applied to most every page component. When such are applied as server-side conditions and/or even page processing conditions, etc, you should find adequate support.

  • mark.daems OP 1.7 years ago

    @jayson hanes I believe database triggers do allow use of the v and nv functions to retrieve apex session variables. They just return null outside of an APEX app context.