search

kcigeospatial / Inlet-Field-and-Web-App-Configuration

Tracker for the Inlet Cleaning app
https://arcg.is/1imOaC
0 stars 1 forks source link

Turn off assignment tracking trigger #44

Closed talllguy closed 5 years ago

talllguy commented 5 years ago

The early requirement to keep track of updates to the work order number is no longer valid. Therefore, we can turn off that trigger and related table, unless it could be used for other fields. @johnshiu what do you think? Could we use it as an audit log for whenever the #41 ETL runs?

johnshiu commented 5 years ago

Hmm, I would recommend just disabling it altogether for now. The ETL refresh is already logged in a separate table, so we don't need the trigger to track it as well.

johnshiu commented 5 years ago

The trigger has been disabled; I have left the existing tables for now, however, in case they want to resurrect some sort of edit tracking.