Table of Contents

2023.8.0

Schema Changes

Database Schema Diff
Transaction View
Insights View
File Store View
Archive View

Migrations

Database Schema Migration SQL Description
Transaction aom ReplaceFunctionValidateMeterReading DDL Change the ValidateMeterReading function to set the exception hint instead of detail. This way when the database option to include error details is off, the message code set in the exception can be returned.
Transaction ampc AddFollowUpTaskInfoTypeMigration DDL Add the ampc.follow_up_task_info used for generating follow up work order tasks
Transaction fin SetAssetFromWorkOrderAssetMigration DML Set Asset Id from Work Order Asset Id.
Transaction res AddResourceTradeFinancialRateMissingFKMigration DDL,DML Fix broken foreign keys between res.resource_trade_financial_rate and res.resource_trade.
Transaction system UpdateDefaultPageLimitColumnMigration DDL Update System Option Page Limit to the System Option table.
Transaction docs VanillaProfilesToCustomResourceActionMigration DML Migrate Vanilla Work Orders Dashboard and Work Orders Recursive Dashboard Profiles to new resource action customisations.
Transaction ampc AddUniqueConstraintToAssetFmecaMigration DDL Add Unique Constraint To Asset Fmeca table
Transaction ampc AddUniqueConstraintToAssetTypeFmecaMigration DDL Add Unique Constraint To Asset Fmeca table
Transaction ampc AlterAssetFmecaByCreatingAndLinkingAssetFunctionsMigration DDL Alter ampc.asset_type_fmeca table, add sync related columns
Transaction ampc AddAssetFmecaSyncFunctionsMigration DDL Add functions for Asset Fmeca sync.
Transaction ampc AddAssetFmecaTaskSyncFunctionsMigration DDL Add functions for Asset Fmeca Task sync.
Transaction ampc AddLinkedToEntityTypeColumToAssetFmecaTableMigration DDL Add linked_to_entity_type column to ampc.asset_fmeca table
Transaction ampc AddLinkedToEntityTypeColumToAssetTypeFmecaTableMigration DDL Add linked_to_entity_type column to ampc.asset_type_fmeca table
Transaction ampc AddAssetTypeFmecaTaskRollOutFunctionsMigration DDL Add functions for Asset Type Fmeca Task roll out.
Transaction ampc AssetTypeFmecaRolloutMigration DDL Add extend functions used by Asset Type Fmeca rollout
Transaction ampc AlterAssetTypeEntityNearestRegularAssetTypeIdFunctionMigration DDL Alter ampc.asset_type_entity_nearest_regular_asset_type_id function.
Transaction ampc AddRollOutUpdateAssetTypeFunctionExtentFunctionMigration DDL Add ampc.roll_out_update_asset_type_function_extent function.
Transaction ampc AddAssetTypeFunctionRollOutFunctionsMigration DDL Add functions for Asset Type Function roll out.
Transaction ampc AddAssetFunctionSyncFunctionsMigration DDL Add functions for Asset Function roll out.
Transaction ampc AddAssetFunctionTableMigration DDL Add ampc.asset_function table
Transaction ampc AddAssetFmecaTaskTableMigration DDL Add ampc.asset_fmeca_task table
Transaction ampc RemoveAssetFmecaTaskColumOnAssetFmecaTableMigration DDL Remove asset_fmeca_task_id column on ampc.asset_fmeca table
Transaction ampc RemoveMTBFAndPFAndFailureDistributionColumOnAssetFmecaTableMigration DDL Remove MTBF, PF and Failure Distribution column on ampc.asset_fmeca table
Transaction ampc AddAssetTypeFmecaTaskTableMigration DDL Add ampc.asset_type_fmeca_task table
Transaction ampc RemoveAssetTypeFmecaTaskColumOnAssetTypeFmecaTableMigration DDL Remove asset_type_fmeca_task_id column on ampc.asset_type_fmeca table
Transaction ampc RemoveMTBFAndPFAndFailureDistributionColumOnAssetTypeFmecaTableMigration DDL Remove MTBF, PF and Failure Distribution column on ampc.asset_type_fmeca table
Transaction ampc AddAssetTypeFunctionTableMigration DDL Add ampc.asset_type_function table
Transaction ampc AddAssetTypeFunctionColumToAssetTypeFmecaTableMigration DDL Add asset_type_function_id column to ampc.asset_type_fmeca table
Transaction ahm AddBoundColumnsToMonitoringPointMigration DDL Add Bound Columns To Monitoring Point Migration
Transaction ahm AddBoundColumnsToMonitoringPointTypeMigration DDL Add Bound Columns To Monitoring Point Type Migration
Transaction ahm SetMonitoringPointBoundsFromTriggersMigration DML Set bound columns on monitoring points from monitoring point triggers Type Migration
Transaction ampc AddTriggerColumnsToAssetTaskFollowUpTaskMigration DDL Add Trigger Columns To Asset Task Follow Up Task
Transaction ampc AddTriggerColumnsToAssetTypeTaskFollowUpTaskMigration DDL Add Trigger Columns To Asset Type Task Follow Up Task
Transaction system DeleteFollowUpWorkOrderStatusMigration DML delete any system option work order statuses with ValidationType = 'FollowUpWorkOrder' and base status awaiting approval or cancelled
Transaction wm AddWorkOrderTaskMonitoringPointTableMigration DDL Add Work Order Task Monitoring Point Table
Transaction wm AddPassedConstraintToWorkOrderTasksMigration DDL,DML Add constraint to work_order_task that if the task is not complete then passed must be null
Transaction wm AddMonitoringPointReadingDetailsTypeMigration DDL Add Monitoring Point Reading Details Type Migration
Transaction wm InsertWorkOrderMonitoringPointsMigration DML Insert work order task monitoring points and work order monitoring points from work order tasks
Transaction ampc FixInvalidForeignKeysMigration DDL,DML Fix inherited from foreign keys that was incorrect.
Transaction docs InsertTemplateVersionInfoMigration DML Add version_info to all template customisations
Transaction docs UpdateTemplateVersionInfoMigration DML Update version_info for templates with no migrations required
Transaction gen FixInvalidForeignKeysMigration DDL Fix inherited from foreign keys that was incorrect.
Transaction gen InsertLocalisationKeysMigration DML Insert the localistion key records for the new translations of the release.
Transaction system InsertTransactionDatabaseEntityTypesMigration DDL Insert the missing entity type values for the release.
Transaction uam AddInsertTenantAdminUserMigration DDL Add function to insert tenant administrator user.
Transaction uam InsertPermissionRegistryMigration DML Populate the uam.permission_registry table with all the latest permissions for the release.
Insights system InsertInsightsDatabaseEntityTypesMigration DDL Insert the missing entity type values for the release.