Part Three – Platform Enhancements for Web Central V23.2

Platform Enhancements for Web Central V23.2, Part 3: Add-in Manager Features for Web Central Smart Client

In the last part of the platform enhancements for Web Central version 23.2, we take a closer look at add-in manager features for Web Central Smart Client V.23.2 includes a number of advances for add-in managers to help them personalise and extend ARCHIBUS.


Scripted Database Updates - To date, administrators have updated their database to support new versions using the Database Update Wizard  (if they have not altered the stock schema) or with the Schema Change Wizard  (if they have altered the stock schema).


V.23.2 adds an additional ability to update your ARCHIBUS database using a master script. The update-schema.duw applies the schema changes made since V.23.1 and the update-sample-data.duw applies the sample data changes made since V.23.1.



To use the master scripts:

  • Navigate to the System Administration / Add-in Manager process and select Run Database Update Wizard
  • Select the Run Script option and press Next
  • Select Server File, enter "projects/users/public/dt/23.2" as the location, and press Refresh
  • Select either the update-schema.duw or the update-sample-data.duw
  • Select Run Script


The master update scripts call a series of sub-scripts to add changes for the ARCHIBUS platform and for each ARCHIBUS domain.


The scripts are useful for Administrators who want:

  • a quick way to update to the new schema
  • their own automated way to update many similar ARCHIBUS deployments (e.g. a series of stock deployments hosted on their cloud servers)
  • to review the specific database changes between ARCHIBUS versions by examining the script files


Administrators may still prefer to use the Schema Change Wizard to review differences between personalised databases and the stock schema. The Schema Change Wizard has tools to analyse the differences, present them, and accept or reject changes singly or in groups. Administrators may also prefer the Schema Change Wizard if they wish to make changes, such as widening fields, before applying them.



Add-in Manager Extension Environment


ARCHIBUS has made a series of improvements to the add-in manager extension environment. There are a number of drivers for this change:

  • Industry Conventions. Industry conventions for managing extensions (e.g. .jar files) have changed, and ARCHIBUS now obeys these "one folder/one project per jar" conventions
  • Security. Security concerns have broadened the adoption of tools to manage provenances and updates to .jar file versions explicitly, and ARCHIBUS now works with .jar files explicitly named for each version
  • Complexity. Complex inter-dependencies in source libraries require the use of automated tools to track specific .jar files and all dependency relationships. Tracking these dependencies explicitly greatly reduced the chance of a base library causing regression errors. With the new structure, ARCHIBUS, and all of the libraries it depends on can be managed by these tools.
  • Build Scripts with Gradle. The ARCHIBUS build process is now managed through Gradle, a powerful build language that allows flexibility and control flow, including conditional statements and loops. Most importantly, Gradle and the new build structure allows the built environment to break down the product into components and sub-components. Dependencies between these components and sub-components can be explicitly declared so that the Gradle build files can be managed independently. As a result, the entire build structure is more robust, and add-in managers can change the Gradle build script for a sub-component without needing to change or understand the building structure of the entire product.
  • Source Code Control Integration with Git. In order to manage changes to applications, most add-in managers use some form of source code control, with the most heavily used being Git. The new structure of the add-in environment enables you to perform all Source Code Control actions with Git directly within Eclipse. Git has powerful features for managing and merging changes. Moreover, Git has extensive features for organising different branches of the repository to manage separate features and changes in an orderly fashion.


Optional SQL Restrictions

V.23.1 supports optional restrictions that can be enabled or disabled using parameters passed from the view to the data source. This feature allows applications to define complex SQL restrictions in server-side data sources, instead of passing them from JavaScript code.


V.23.2 enhances optional restrictions:

  • Optional SQL clauses inside SQL queries. Reports that use complex SQL queries can be designed to include optional SQL clauses into specific parts of the SQL query. Optional clauses will apply only if the UI form passes a parameter that enables the clause.
  • Optional SQL restrictions for field values. Complex filter consoles that have many optional fields can be designed to use an optional restriction per field. The restriction will apply only if the user has supplied the field value.


Shared optional SQL restrictions - Add-in managers can define optional restrictions in reusable data sources, and use them in other, view-specific data sources.


HTML Drawing Control Enhancements - The V.23.2 HTML drawing control has been improved to include the majority of the features of the Flash drawing control along with a wealth of new features to support advanced applications.



The V.23.2 HTML drawing control has been improved to include the majority of the features of the Flash drawing control, along with a wealth of new features to support advanced applications.


New features include:

  • Common Drawing Controller: implements typical drawing use cases and simplifies application development
  • Ability to display multiple drawings
  • Selection of assets and layers in multiple drawings 
  • Drag and drop of assets between multiple drawings and the asset window
  • Hatch pattern/gradient highlights
  • Border highlights
  • Highlight and border highlight legend panels
  • Mouse zoom, pan, and zoom window
  • Redlining API


With these features, V.23.2 has replaced all of the Flash drawing and charts with HTML5 drawings and charts. The previous Flash features are still supported so that add-in managers can continue to run personalised views that use Flash.


  • Process Navigator: Technologies / User Interface Add-Ins / HTML5 Drawing Views



Data Sources in Custom Select Value Dialogs - Add-in managers can implement custom Select Value dialogues that load data from data sources defined in AXVW files. This is recommended when the Select Value dialogue should apply a restriction to displayed data.


Our blogs on Platform Enhancements for Web Central V23.2 have now come to an week our blog will be on a Strategic Partnership with Cadassist so check back next week to see that.


Contact our team at MASS if you have any questions on the new Platform Enhancements. We are available on 0118 977 8560 or email us at to find out more.

If there are any other topics you would like us to cover in our blogs please let us know.

Andrew Taylor







MASS visited Dublin...again! 10/04/2019

Due to the success of 2018’s Dublin Roadshow, we just couldn’t resist making another visit to Dublin. This year, we hosted at the centrally located Temple Bar Hotel, which as the name sug...
read more view all blog posts