Misc Notes

Owned by Boris Berenberg - Atlas Authority (Unlicensed)
Last updated: Aug 18, 2020
1 min read

Bulk Updating Executing Users

If you need to bulk update the Executing User field we have a SQL query that you can use for this. This has only been tested on PostgreSQL, and we strongly encourage you to take a backup first.

UPDATE "AO_F9C6CD_NAFJ_N" SET "ACTOR_USER" = <username>

Bulk Updating Whether Templates Include Changed fields

If you need to bulk update the Include Field Changes option in all of your Notification Templates, we have a SQL query that you can use for this. This has only been tested on PostgreSQL, and we strongly encourage you to take a backup first.

UPDATE "AO_F9C6CD_NAFJ_ET" SET "INCLUDE_CHANGES" = <boolean value>;