AnsweredAssumed Answered

Oracle Trigger in a versioned point feature class

Question asked by thiyag on Apr 22, 2019
Latest reply on May 1, 2019 by ppapadopoulosmarathondata-gr-esridist

I have a point feature class that I published with feature access enabled with Create, Update and Sync options. 

 

The feature class has object ID, Global ID, Notification number, notification created date, due date, comments, work order. I enabled keep tracking on edits on the feature class. So it created Created date, created by, last edited date and edited by fields. The feature class is versioned as well.

 

One of the team that I work with uses applyEdits REST endpoint of the feature service to post data to the feature class.

 

All they do is insert into the feature class through applyEdits which is on a daily basis. My condition is, if the notification number already exist in feature class, it should update the corresponding values for that particular record. If not, it should insert a new record. 

 

I tried creating trigger on Adds table from Oracle following this link but I have very limited knowledge on python and oracle. 

 

https://community.esri.com/thread/113402-sql-trigger-in-versioned-sde

 

Can someone please point in the right direction how to proceed on about this either using python or FME or any other ways? 

 

Really appreciate your time and consideration. 

Outcomes