Can you provide some more details around what you're looking for? I'm not aware of an upsert trigger, but some additional context may help clear things up.

Hi Annakula,

After my research came to know about upsert trigger model - it needs to be able to "save" an instance without knowing for sure whether the record for that instance already exists or not.

Let's say if the instance does not exist yet, then we attempt to use an INSERT to write the instance.  If this results in a primary key constraint violation, then we attempt to do an UPDATE.

Similarly when the instance does exist, then we attempt to use an UPDATE to write the instance.  If this results in zero rows actually being updated, then we attempt to do an INSERT.

Couldn't find much information about the upsert trigger model apart from this, hope it might help you.

Regards

Mahesh M