What's new in Version 6.12.2
Tables - Related Objects
Administrators can now view all system objects that reference a given Table.
On each defined Table Setup, viewed under the COG menu, a new 'Related Objects' tab has been introduced. This tab displays a list of the below objects in the application that references the given Table in view:
- Reports
- Participant Modules
- Plan Template: Components
- Transform Data
- Custom Importers

The related objects are listed according to the Name of the object, and a magnifying glass icon is available for Administrators to open the related object in another tab within the browser. In addition, if the object is not yet published, then a status of "Unpublished" is displayed next to the object’s Name.
When Administrators attempt to delete a Table with at least one related object referenced, then the following error message is encountered.
The Table can only be removed once all related objects have been removed or no longer reference the given Table.
NOTE: The following objects are not yet included on the Related Objects tab, and will be added in a future release.
- Report: Leader Board Report
- Leader Board Calculation
- Scripted Custom Importers
Therefore an Administrator will not be prevented from deleting a Table when related to only these objects.
Batches - Related Objects
Administrators can now view all system objects that reference a given Batch.
On each defined Batch, viewed under the COG > Batches menu, a new 'Related Objects' tab has been introduced. This tab displays a list of the below objects in the application that references the given Batch in view, whether it be a Scheduler or another Batch.
The related objects are listed according to the Name of the object, and a magnifying glass icon is available for Administrators to open the related object in another tab within the browser.
In addition:
- If the Batch is not published, then a status of "Unpublished" is displayed next to the object’s Name
- If the Scheduler is not active, then a status of “Deactivated” is displayed next to the object’s Name
When Administrators attempt to delete a Batch with at least one related object referenced, then the following error message is encountered.
The Batch can only be removed once all related objects have been removed or no longer reference the given Batch.
Bugs
- Fixed the Salesforce Multiple Object Importer to stream data in order to prevent out of memory issues when importing a large amount of data.
- Fixed the System Property page to allow values to be cleared successfully, without the user encountering a 500 page error after save.
- Fixed the Table Setup feature to apply additional rules when generating the database name based on input field name, in order to prevent subsequent issues with related objects. Firstly, the field name is now restricted to 255 characters on input. In addition, the field name entered is used to derive the database name, then subsequently the following rules are now applied:
- Non-alphanumeric characters are removed
- Spaces are substituted with underscores
- First 60 Characters are applied
- Duplicate database fields are appended with the next available number - Fixed the Table to Result Transform to restrict Administrators to Input Values, Period or Participant EID when the ‘IN’ operator has been selected as a Criteria definition.
- Fixed the Scheduler page to prevent an invalid custom schedule being defined using the "Cron notation" field.
Also, the following changes have been included:
- The "Cron notation” field is mandatory:
- The "Cron notation" field is not editable on “Simple” schedule types, as the field’s value is automatically generated upon saving the Scheduler.
- A help bubble has been added to assist users in defining custom schedulers