AnsweredAssumed Answered

How to determine if POST_CI trigger fired for UPDATE or INSERT

Question asked by Alan_Eth on Sep 14, 2017
Latest reply on Sep 18, 2017 by jmayer

I have some spel code that is fired by a POST_CI trigger and I want it to take slightly different actions depending on whether the record it is fired on has just been inserted or if it is an older one being updated.


When I've done this with other trigger types I have been able to pass one of the key fields (e.g. persistent_id) as a parameter and the "previous" value of that parameter (e.g. argv[2] rather than argv[3]) has been null, but that doesn't seem to be working in a POST_CI trigger.


Using r12.6.



Help, please.