Skip to main content
Eptura Knowledge Center

Database Schema Revision History V2022.02

  1. Last updated
  2. Save as PDF

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

Localization

These files update the translation of new strings:

  • /webapp/projects/users/public/dt/v2022.02.002/translation/update-translation-doublebyte.duw

  • /webapp/projects/users/public/dt/v2022.02.002/translation/update-translation-singlebyte.duw

  • /webapp/projects/users/public/dt/v2022.02.002/translation/update-translation-template-doublebyte.duw

  • /webapp/projects/users/public/dt/v2022.02.002/translation/update-translation-template-singlebyte.duw

Sample Data

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

  • AD-8880 : Remove two problematic wr records

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

  • AD-9257 : Forge Integration - sample enterprise graphics records

  • AD-9266 : Forge Integration - map some equipment in building NB to Revit model

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

  • AD-8782 : Create a better demo checklist for OnSite

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

  • AD-9267 : Solutions - Import sample badge swipes data

  • AD-9271 : Solutions - Import sample IoT sensor data on space utilization

Schema - 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.02.001/schema-template/update-schema-template.duw makes these updates :

  • AD-8879 : Change default value of ShowEstimateInWrActions activity parameter.

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

  • AD-8855 : Further reduce precision of some fields in oracle that are out of sync with afm_flds to bring them into alignment with afm_flds.

  • AD-8875 : By default, enable encryption of wfr parameters

Schema - Application Parameters

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

  • AD-8250 : update the description of AbEssentialFacility-UsingMobileApp

  • AD-8197 : update push notification parameters

  • AD-8248 : AbSpaceHotelling-AttachIcsToEmails

  • AD-8249 : AbWorkplaceReservations-PlugInHideButtons

  • AD-8946 : AbWorkplaceReservations-MeetingUrlPatterns

Schema - Maintenance and OnSite

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

  • AD-8812 : Show wr_id info in Activity for follow-up request

  • AD-8744 : Add OnSite push notification subscribe table, update existing afm_notifications_log table for OnSite

  • AD-8742 : Import OnSite push notification titles to message table

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

  • AD-8666 : Schema changes to store checklists to PM procedure steps

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

  • AD-8699 : Fix English spelling of activity parameter description.

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

  • AD-8246 : Fix connect_sla_priority connector to be run manually

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

  • AD-8855 : Fix connect_sla_priority staging table to remove auto-increment from database for priority_id

  • AD-8246 : connect_sla_priority should not import priority_id

Schema - Navigator

The /webapp/projects/users/public/dt/v2022.02.001/schema/app-essential-facility/update-schema.duw makes these updates :

  • AD-8251 : Add task Define Equipment Standards to Foundations under the process Background Data & Reports

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

  • AD-8807 : Change all Workplace PNav entries to point only to Dashboard (no more Services Catalog as landing page) and delete 'My Dashboard' entries to remove duplicate Workplace tasks in same activity id + process id

  • AD-8786 : Add "Define Amenities for Hotelable Rooms" task to Cloud Reservations application, Develop Background Data process

  • AD-8845 : Add Navigator Tasks for Archibus BIM Viewer

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

  • AD-9132 : Add two navigator menu tasks to process 'Partner Administrator - UserSec' to allow partner and client admins to have access to the Add or Edit User Roles and the Assign Security Groups to Roles tasks.

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

  • AD-9132 : Add two navigator menu tasks to process 'Partner Administrator - UserSec' to allow partner and client admins to have access to the Add or Edit User Roles and the Assign Security Groups to Roles tasks.

  • AD-9291: Update Navigator for the process Forge Integration - Update Building Console task title and file

  • AD-9291: Import new tasks for the process Forge Integration

  • AD-9291: Activate the process Forge Integration

Schema - Mobile

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

  • AD-8575 : Increase size of the log_message field

Schema - Workplace app and Workplace Services

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

  • AD-8698 : Add WFR for Workplace Usage Analytics

The / webapp/projects/users/public/dt/v2022.02.001/schema/app-workplace-reservation/update-schema.duw makes these updates :

  • AD-6720 : Update wfr-rule schedule settings

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

  • AD-8162 : Change report title from "Bookings & Reservations" to "Workplace Utilization"

Schema - System

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

  • AD-8568 : Have a gender neutral option for the honorific field

  • AD-8809 : Increase the size of the message_text field.

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

  • AD-9033 : BIM Viewer - importing new application, AbDigitalTwin used for licensing the BIM Viewer

  • AD-8855 : Add workflow rule to present data event logs

  • AD-8403 : CAD/BIM - Import Application Parameters for AutoCAD and Revit Publishing Preferences

  • AD-9256 : CAD/BIM : New task for configuring CAD publishing parameters

  • AD-9258 : CAD/IM : Integration with Autodesk Forge - New application parameter for authentication service URL