Skip to main content
Eptura Knowledge Center

Database Schema Revision History V2022.03

  1. Last updated
  2. Save as PDF

For details on the exact changes for the V.2022.03 database, see the following files:

Sample Data

The /webapp/projects/users/public/dt/v2022.03.002/sample-data/update-sample-data.duw makes these updates:

  • AD-10410 : BIM Viewer - Import sample active work requests and equipment diagnostics

The /webapp/projects/users/public/dt/v2022.03.001/sample-data/app-bim-viewer/update-sample-data.duw makes these updates:

  • AD-9711: Update site code for equipment where site code is missing

The /webapp/projects/users/public/dt/v2022.03.001/sample-data/app-bldgops/update-sample-data.duw makes these updates:

  • *AD-9586: Update SERVICE DESK - DEPARTMENT SPACE SLA step from type 'review' to 'approval'

Schema Template

The Schema Template holds changes to the schema database that do not necessarily apply to an upgrade. This includes changes that could overwrite production data. The schema template is a distinction between the use of scripts as documentation of changes to schema as a template, and a method to upgrade a database.

The /webapp/projects/users/public/dt/v2022.03.001/schema-template/pnav/update-schema-template.duw makes these updates:

  • AD-9597 : remove BIRT views from navigator

Application Parameters

The /webapp/projects/users/public/dt/v2022.03.001/schema/activity-params/update-schema.duw makes these updates:

  • AD-9431 : added new application parameters for onsite mobile

  • AD-9518 : added new application parameter to support private meetings

Esri

The /webapp/projects/users/public/dt/v2022.03.001/schema/app-arcgis/update-schema.duw makes these updates:

  • AD-9973 : schema updates for Extensions for Esri

Maintenance (Building Operations)

The / webapp/projects/users/public/dt/v2022.03.001/schema/app-bldgops/update-schema.duw makes these updates:

  • AD-9648 : update status change push notification title message and drop field 'afm_notifications_log.wr_id'

  • AD-9558 : onsite per user configuration

  • AD-9806 : import scheduled workflow rule AbBldgOpsOnDemandWork-AutoDeleteOnSitePushNotifications

The /webapp/projects/users/public/dt/v2022.03.002/schema/app-bldgops/update-schema.duw makes these updates:

  • AD-8076 : Labor Scheduler - add application parameter to config MaxScheduledJobsPerPersonPerDay

  • AD-10335 : Forge Service Access - set the default url to the production forge microservice access

  • AD-10370 : Forge Viewer Access - add new application parameter for storing the Archibus BIM Customer Key

Reservations

The /webapp/projects/users/public/dt/v2022.03.001/schema/app-reservations/update-schema.duw makes these updates:

  • AD-9518 : new message to support private meetings

Solution Sample Views

The /webapp/projects/users/public/dt/v2022.03.001/schema/app-solutions/update-schema.duw makes these updates:

  • AD-9220 : add back the five AbSolutionsWorkflow workflow rules

Space

The /webapp/projects/users/public/dt/v2022.03.001/schema/app-space/update-schema.duw makes these updates:

  • AD-9978 : add a "RetainDrawingPublishedColors" application parameter

  • AD-9295 : Schema Changes to store PDF labels options - afm_dwg_label_size

OnSite

The /webapp/projects/users/public/dt/v2022.03.002/schema/onsite/update-schema.duw makes these updates:

  • AD-10266 : Remove Value '2' from two NotificationNewRequest parameters

The /webapp/projects/users/public/dt/v2022.03.001/schema/onsite/connect/update-schema.duw makes these updates:

  • AD-8253 : delete unused onsite connect staging table fields

Navigator

The / webapp/projects/users/public/dt/v2022.03.001/schema/pnav/update-schema.duw makes these updates:

  • AD-9646 : FloorViewPrint-01-1: add the view to PNAV tasks

  • AD-8480 : Manage Configurations for OnSite: add the view to PNAV tasks

The /webapp/projects/users/public/dt/v2022.03.002/schema/system/pnav/update-schema.duw makes these updates:

  • AD-10334 : BIM Viewer - Navigator - Adding task for cataloging BIM models

  • AD-10338: BIM Viewer - Navigator - Adding task for connecting BIM Viewer to Autodesk account

System

The /webapp/projects/users/public/dt/v2022.03.001/schema/system/update-schema.duw makes these updates:

  • AD-9668 : remove BIRT wfr

  • AD-8408 : Add default value for date_created field

  • AD-9582 : Modify afm_notifications_log and docs_assigned to store mail message and attachments

  • AD-10015 : Remove WFRs that reference DocumentHandlers Java class

  • AD-9669 : delete obsolete activity parameter EncryptWorkflowRuleParameters which is now always on

The /webapp/projects/users/public/dt/v2022.03.002/schema/system/update-schema.duw makes these updates:

  • AD-10400: Add new status values to enum_list of afm_notifications_log

  • AD-5442 : badge data import should not import duplicate entries

  • AD-3538 : set SYS-USRMGR edit group on all afm_users fields except transfer status.