This page (revision-5) was last changed on 26-Nov-2021 10:22 by rforbes

This page was created on 26-Nov-2021 10:22 by RForbes

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
5 26-Nov-2021 10:22 4 KB rforbes to previous
4 26-Nov-2021 10:22 4 KB rforbes to previous | to last
3 26-Nov-2021 10:22 4 KB rforbes to previous | to last
2 26-Nov-2021 10:22 3 KB RForbes to previous | to last
1 26-Nov-2021 10:22 3 KB RForbes to last

Page References

Incoming links Outgoing links
DATA BASE TRIGGER
DATA BASE TRIGGER

Version management

Difference between version and

At line 5 changed one line
Within the Personality application, triggers are used as noted:
Within the [{$applicationname}] application, triggers are used as noted:
At line 10 changed one line
* Set values for [CREATE_DATE] and [CREATE_USER];
* Set values for CREATE_DATE and CREATE_USER;
At line 16 changed one line
* Set values for [CHANGE_DATE] and [CHANGE_USER];
* Set values for CHANGE_DATE and CHANGE_USER;
At line 30 changed one line
These triggers, identified by a naming convention of __P2K_xxx_BIUD__ (where xxx is the [table alias|TABLE_ALIAS]) are used to control the processing of [workflow|MODULE-WF], if defined. The trigger fires after all the data has been manipulated, but just prior to the actual commit to the data base (BEFORE INSERT, UPDATE, DELETE). Triggers are created by the ''seed_create_BIUD.sql'' script and dropped using the ''db_drop_wf_triggers.sql'' script.
These triggers, identified by a naming convention of __P2K_xxx_BIUD__ (where xxx is the [table alias|TABLE_ALIAS]) are used to control the processing of [workflow|MODULE-WF], if defined. The trigger fires after all the data has been manipulated, but just prior to the actual commit to the data base (BEFORE INSERT, UPDATE, DELETE)
At line 36 added 2 lines
[{If var='loginstatus' contains 'authenticated'
At line 37 changed 2 lines
![Notes|Edit:Internal.DATA+BASE+TRIGGER]
[{InsertPage page='Internal.DATA+BASE+TRIGGER' default='Click to create a new notes page'}]
![Discussion|Edit:Internal.DATA+BASE+TRIGGER]
[{InsertPage page='Internal.DATA+BASE+TRIGGER' default='Click to create a new discussion page'}]
}]
This page (revision-5) was last changed on 26-Nov-2021 10:22 by rforbesTop