--- title: "Release Note: DataJet vJun2023" slug: "release-note-datajet-v5-6-30" updated: 2023-07-13T18:26:51Z published: 2023-07-13T18:26:51Z canonical: "docs.datajet.app/release-note-datajet-v5-6-30" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.datajet.app/llms.txt > Use this file to discover all available pages before exploring further. # Release Note: DataJet v5.6.30 ## Overview ### Key Features The key features of this release are: - Component upgrades to .NET 6 (which results in DataJetExplorer.exe now shipping with support components) - [A new scripting system for managing Global scripts across multiple realms](/v1/docs/release-note-datajet-v5-6-30#global-script-hub) - [**Prototype: ability to share tables between projects on the same realm**](/v1/docs/release-note-datajet-v5-6-30#ability-to-share-tables-and-links-across-projects) - [**Prototype: ability to inject shared data across realms**](/v1/docs/release-note-datajet-v5-6-30#ability-to-share-tables-and-links-across-projects) ### Administration - [Remote Script Execution](/v1/docs/release-note-datajet-v5-6-30#remote-script-execution) - [DJExplorer now ships in a zip file.](/v1/docs/release-note-datajet-v5-6-30#djexplorer-now-ships-in-a-zip-file) - [Smoke Test script to verify installations](/v1/docs/release-note-datajet-v5-6-30#smoke-test-script-to-verify-installations) - [Ability to configure OUTPUT locations](/v1/docs/release-note-datajet-v5-6-30#ability-to-configure-output-locations) - [Unencrypted client config file](/v1/docs/release-note-datajet-v5-6-30#unencrypted-client-config-file) - [Additional messaging on failed logins](/v1/docs/release-note-datajet-v5-6-30#additional-messaging-on-failed-logins) - [Repository size displayed in Project Manager](/v1/docs/release-note-datajet-v5-6-30#repository-size-displayed-in-project-manager) ### API - Modified Method: [ExecuteScript](/v1/docs/release-note-datajet-v5-6-30#changes-to-api-methods) - Modified Method: [ExecuteStoredScript](/v1/docs/release-note-datajet-v5-6-30#changes-to-api-methods) - Modified Method: [BuildBakedField](/v1/docs/release-note-datajet-v5-6-30#changes-to-api-methods) - numberband - Modified Method: [BulkDecode](/v1/docs/release-note-datajet-v5-6-30#changes-to-api-methods) - New Method: [InjectTable](/v1/docs/release-note-datajet-v5-6-30#changes-to-api-methods) - New Method: [InjectTables](/v1/docs/release-note-datajet-v5-6-30#changes-to-api-methods) - New Method: [DetachTable](/v1/docs/release-note-datajet-v5-6-30#changes-to-api-methods) - New Method: [SetObjectProperty](/v1/docs/release-note-datajet-v5-6-30#changes-to-api-methods) - New Method: [Test](/v1/docs/release-note-datajet-v5-6-30#changes-to-api-methods) - New Method: [InjectPackage](/v1/docs/release-note-datajet-v5-6-30#changes-to-api-methods) - New Method: [TrackScript](/v1/docs/release-note-datajet-v5-6-30#changes-to-api-methods) ### Engineering and Analytics - [New Expression Builder Functions](/v1/docs/release-note-datajet-v5-6-30#new-expression-builder-functions) - [New DateTime formats](/v1/docs/release-note-datajet-v5-6-30#new-datetime-formats) - [Ability to specify sort order for fields](/v1/docs/release-note-datajet-v5-6-30#ability-to-specify-sort-order-for-fields) - [RIGHTOF extended to support continuous strings](/v1/docs/release-note-datajet-v5-6-30#rightof-extended-to-support-continuous-strings) - [MIN and MAX accepted in Banding](/v1/docs/release-note-datajet-v5-6-30#min-and-max-accepted-in-banding) - [New Functions: SWEEKDAYX(A), SMONTHX(A)](/v1/docs/release-note-datajet-v5-6-30#new-functions-sweekdayxa-smonthxa) - [OrderByLabel support for Banding](/v1/docs/release-note-datajet-v5-6-30#orderbylabel-support-for-banding) ### Scripting - [Script Metadata](/v1/docs/release-note-datajet-v5-6-30#global-script-hub) - [Global scriptserver](/v1/docs/release-note-datajet-v5-6-30#global-script-hub) ### Database Build, Export and Management - [Ability to share tables and links across projects](/v1/docs/release-note-datajet-v5-6-30#ability-to-share-tables-and-links-across-projects) - [FIX: Loading unbalanced quotes causes issues with Data Audit, Export and Metadata Categories](/v1/docs/release-note-datajet-v5-6-30#bug-fixes) - [Ability to toggle Delete Protection for fields and tables](/v1/docs/release-note-datajet-v5-6-30#ability-to-toggle-delete-protection-for-fields-and-tables) - [Repository Size added to Project Manager](/v1/docs/release-note-datajet-v5-6-30#repository-size-added-to-project-manager) - [Remote File Manager ignores rights-violations](/v1/docs/release-note-datajet-v5-6-30#remote-file-manager-ignores-rightsviolations) - [FIX: ExportIntoTable failing when exporting decode source fields](/v1/docs/release-note-datajet-v5-6-30#bug-fixes) ### General Desktop UI - [Remote Data Source Dialog Improvements](/v1/docs/release-note-datajet-v5-6-30#remote-data-source-dialog-improvements) - [Database Explorer has Right-click Engineering Options for Tables](/v1/docs/release-note-datajet-v5-6-30#database-explorer-has-rightclick-engineering-options-for-tables) - [Ability to Hide/Show Project Explorer](/v1/docs/release-note-datajet-v5-6-30#ability-to-hideshow-project-explorer) - [All tables and fields are in case-insensitve sorted order in all combo boxes](/v1/docs/release-note-datajet-v5-6-30#all-tables-and-fields-are-in-caseinsensitve-sorted-order-in-all-combo-boxes) - [Ability to Show/Hide fields and tables](/v1/docs/release-note-datajet-v5-6-30#ability-to-showhide-fields-and-tables) - [FIX: BrowseToSet stripping underscores out of keys](/v1/docs/release-note-datajet-v5-6-30#bug-fixes) ## Breaking Changes Tables loaded before this version cannot be injected and will need to be reloaded. ## BUG Fixes | Fix for issue when loading unbalanced quotes in field descriptions - causing issues with Data Audit, Export and Metadata Categories | | --- | | Fix for missing underscores in variable paths | | For for ExportIntoTable failing when exporting decode source fields in place of decode | ## Known Issues/Constraints - Tables loaded in older versions of the software cannot be injected - they must be reloaded with this version or later ## Changes to API Methods The following API methods have been added or modified in this release: | Category | Method | Description | | --- | --- | --- | | General | [ExecuteScript](/v1/docs/executescript) | New properties: - quiet - scriptFilename - logFilename | | General | [ExecuteStoredScript](/v1/docs/executestoredscript) | New property: - realm | | Engineering | [BuildBakedField](/v1/docs/buildbakedfield) | New property: - orderByLabel | | Engineering | [BulkDecode](/v1/docs/bulkdecode) | New properties: - errorOnRename - skipIfExistingSource | | Data Model | [InjectTables](/v1/docs/injecttables) | **PROTOTYPE** Injects a read-only copy of a table from a source project into a target project | | Data Model | [InjectTable](/v1/docs/injecttable) | **PROTOTYPE** Injects shared tables (and joins) from a source project into another project. | | Data Model | [InjectPackage](/v1/docs/injectpackage) | **PROTOTYPE** Injects a shared data package that has been created using Backup. | | Data Model | [DetachTable](/v1/docs/detachtable) | **PROTOTYPE** Removes an injected/shared table from a target project | | Config | [SetObjectProperty](/v1/docs/setobjectproperty) | Delete Protection can be toggled via DELETEPROTECT property. | | Administration | [Test](/v1/docs/test-1) | Runs a series of tests that verify Datajet Server configuration and installation | | Administration | [TrackScript](/v1/docs/trackscript) | Used to track status of an executing script | ## Feature Details #### Remote Script Execution Remote scripts can be executed by an authorised agent using restAPI and the [ExecuteStoredScript](/v1/docs/executestoredscript) method - Script Editor is an example of an authorised agent. Speak to a system administrator for details on how to configure an authorised agent. ```json curl --location 'http://107.152.32.41:5555' \ --header 'Content-Type: application/json' \ --data '{ "method": "ExecuteStoredScript", "projectName": "SharedLibrary", "name": "MyStoredScript", "scriptId": "providedscriptid", "debug": true, "targetProject": "ProjectToBeModified", "variables": { "%Variable1%": "value1" }, "project": "CurrentProject" "authToken":"%AuthTokenHere%" }' ``` Remote Script Execution can be monitored using [TrackScript](/v1/docs/trackscript): ```json { "method": "ExecuteStoredScript", "authToken":"%AuthTokenHere%" "scriptId": "madeupscriptid0001", "name": "Regression Reports", "targetProject": "RegressionDB" "projectName":"RegressionDB" } { "method": "TrackScript", "authToken":"%AuthTokenHere%" "scriptId": "madeupscriptid0001", "statusOnly":true, } ``` #### DJExplorer now ships in a zip file. DataJet Desktop Client (DatajetExplorer.exe) now ships with a list of support components and so ships as a zip file rather than a single executable. ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1686239621130.png) #### Smoke Test script to verify installations The [Test](/v1/docs/test-1) method can be executed to determine whether the target DataJet server has been correctly installed. ```json { method: "Test" test:CheckEngine } ``` #### Unencrypted client config file A new client config file which is configurable by company administrators is available. DataJet Server now uses multiple configuration files - one encrypted, one unencrypted. djclient.cnfg should be present in the same location as the djserver.cnfg file - speak to a system administrator to find out where these files are located. For details of what can be configured in the djclient.cnfg file, see [Client Configuration](/v1/docs/client-configuration-file). #### Ability to configure OUTPUT locations The default team and user output locations are subsets of the Realm Folder (see architecture for single realm for more information). These locations can now be configured using the command line options of - useroutput== - systemoutput== See [Command Line Options](/v1/docs/command-line-options) for more details. #### Ability to specify sort order for fields #### Additional messaging on failed logins - **Login Failed - Bad Credentials**:   username or password is incorrect - **Login Failed - No Core**:  there is a problem communicating with the server core. #### Repository size displayed in Project Manager Project DiskSize is now included in Project | Manage: ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1686572847673.png) #### New Expression Builder Functions **5th Percentile** - **Engineering |** [**Expression Builder**](/v1/docs/expression-field) **| Field Attributes: pc5** - fpc5(field) - 5th percentile for this field **95th Percentile** - **Engineering | Expression Builder |** **Field Attributes: pc95** - fpc95(field) - 95th percentile for this field #### New DateTime formats - "MM-DD-YYYY HH:MM:SS" - "DD-MM-YYYY HH:MM:SS AM" - "MM-DD-YYYY HH:MM:SS AM" #### OrderByLabel support for Banding - Optional **"orderByLabel": true** key when using BuildBakedField - numberband ```json { "method": "BuildBakedField", "targetTable": "Sales", "p1": "Profit", "overwrite": true, "name": "Profit_banded", "function": "numberband", "label": [ "-6600 < -4725", "-4725 < -2850", "-2850 < -975", "-975 < 900", "900 < 2775", "2775 < 4650", "4650 < 6525", "6525 < 8401" ], "low": [ "-6600", "-4725", "-2850", "-975", "900", "2775", "4650", "6525" ], "high": [ "-4725", "-2850", "-975", "900", "2775", "4650", "6525", "8401" ], "orderByLabel": true, "project": "Demonstration" } ``` #### RIGHTOF extended to support continuous strings The Engineering | Functions | String | [RightOf](/v1/docs/rightof) function now supports a Continuous String as input. #### MIN and MAX accepted in Banding When specifying upper and lower ranges for banded fields, the desktop application now supports putting MIN for the lowest lower band and MAX for the highest upper band. ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1686844102085.png) #### New Functions: SWEEKDAYX(A), SMONTHX(A) SWEEKDAYX(A) - **Engineering | Function Field | Functions | DateTransform | SWEEKDAYX** - Automatically displays Weekdays in chronological order, rather than alphabetic - Useful for reporting SMONTHX(A) - **Engineering | Function Field | Functions | DateTransform |** **SMONTHX(A)** - Automatically displays months in Chronological order, rather than alphabetical - Useful for reporting #### Global Script Hub Multiple engine instances can now share scripts via a Script Storage Hub. Multi-realm scripts are stored in a protected realm, called "global" Script Hubs are configured via djclient.cnfg Simple Script versioning, version history and execution history is available. See [Script Hub](/v1/docs/script-hub-overview) for more details. ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1687374421498.png) #### #### Ability to share tables and links across projects A prototype version of shared data is now available - this allows data from one project to be used in a read-only capacity by other target projects, both on the same realm, and across multiple realms and servers. Please consult with a DataJet Administrator to help configure or design systems to use this paradigm. See [Deep Dive - Sharing Data by Injection](/v1/docs/deep-dive-sharing-data-by-injection) for a detailed overview of sharing data. The following API methods are used to manage shared data: - [InjectTable](/v1/docs/injecttable) - [InjectTables](/v1/docs/injecttables) - [InjectPackage](/v1/docs/injectpackage) - [DetachTable](/v1/docs/detachtable) #### Ability to toggle Delete Protection for fields and tables Tables and fields can be protected so that they cannot be accidently deleted. To toggle protection, right-click the object in the Project Explorer and choose Protect: ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1688666046900.png) #### Repository Size added to Project Manager Project Manager now includes the disksize for a project. ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1688384960191.png) #### Remote File Manager ignores rights-violations Remote File Manager is now able to display a full directory and file list on systems where rights-violations were preventing display. Optimisations have also been made for deployment on slow-seeking file systems. #### Remote Data Source Dialog Improvements The Remote Data Sources dialog has been upgraded to give improve search and filter capabilities. See [Remote File Manager](/v1/docs/remote-file-manager) for further details. ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1688488574848.png) #### Database Explorer has Right-click Engineering Options for Tables Table based engineering functions can now be accessed directly from the right-click menu of a table in the Database Explorer: - [IntegerSequenceKey](/v1/docs/integersequencekey) - [LongSequenceKey](/v1/docs/longsequencekey) - [DiscreteIntegerSequence](/v1/docs/discreteintegersequence) ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1688488739440.png) #### Ability to Hide/Show Project Explorer ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1688666427484.png) #### All tables and fields are in case-insensitve sorted order in all combo boxes ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1688981858544.png) #### Ability to Show/Hide fields and tables Fields can be hidden in the Database Explorer by using the show/hide field dialog: ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1688981987923.png) ### ####