--- title: "Release Note: DataJet vJul2023" slug: "release-note-datajet-v5-18-1" updated: 2023-07-20T17:14:56Z published: 2023-07-20T17:14:56Z canonical: "docs.datajet.app/release-note-datajet-v5-18-1" --- > ## 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.7.18.1 20/07/2023 ## Overview This release focuses on extending support for variable match levels in queries and consolidating flexibility and features for shared data. ### Key Features The key features of this release are: - [PROTOTYPE: Support for multiple heirarchical join conditions when linking tables](/v1/docs/release-note-datajet-v5-18-1#prototype-support-for-multiple-heirarchical-join-conditions-when-linking-tables) - [Ability to hide/show data from primary and injected tables](/v1/docs/release-note-datajet-v5-18-1#showhide-table-and-field-settings-cascade-to-all-desktop-data-displays-and-dialogs) - [Upgraded QueryMatrix report](/v1/docs/release-note-datajet-v5-18-1#querymatrix-productivity-features) #### Administration - [Allow fields to be masked in user interface](/v1/docs/release-note-datajet-v5-18-1#allow-fields-to-be-masked-in-user-interface) - [Global Templates](/v1/docs/release-note-datajet-v5-18-1#global-templates) #### API - [Modified Method: Backup](/v1/docs/release-note-datajet-v5-18-1#changes-to-api-methods) - [Modified Method: InjectTable](/v1/docs/release-note-datajet-v5-18-1#changes-to-api-methods) - [Modified Method: Audit](/v1/docs/release-note-datajet-v5-18-1#changes-to-api-methods) - [Modified Method: ExecuteStoredScript](/v1/docs/release-note-datajet-v5-18-1#changes-to-api-methods) - [New Method: CreatePackage](/v1/docs/release-note-datajet-v5-18-1#changes-to-api-methods) - [New Method: AddJoinLayer](/v1/docs/release-note-datajet-v5-18-1#changes-to-api-methods) - [New Method: InjectReports](/v1/docs/release-note-datajet-v5-18-1#changes-to-api-methods) #### Engineering and Analytics - [QueryMatrix productivity features](/v1/docs/release-note-datajet-v5-18-1#querymatrix-productivity-features) - [FIX: QueryMatrix allows post-processing to toggle/on off](/v1/docs/release-note-datajet-v5-18-1#bug-fixes) - [Increased layout options for mixed-view reports](/v1/docs/release-note-datajet-v5-18-1#increased-layout-options-for-mixedview-reports) - [FIX: Sorting by processed columns in profile reports](/v1/docs/release-note-datajet-v5-18-1#bug-fixes) - [New Function: RPAD](/v1/docs/release-note-datajet-v5-18-1#new-function-rpad) - [Modified Function: DateFromString format can start with # or not](/v1/docs/release-note-datajet-v5-18-1#modified-function-datefromstring-format-can-start-with-or-not) #### Scripting - [Project text box added to Script PUSH](/v1/docs/release-note-datajet-v5-18-1#project-text-box-added-to-script-push) - [Host name and username added to Script COMMIT](/v1/docs/release-note-datajet-v5-18-1#host-name-and-username-added-to-script-commit) - [FIX: Shared script push not updating “last pulled” value that leads to confusing, false warnings.](/v1/docs/release-note-datajet-v5-18-1#bug-fixes) - Prototype: Experimental aSyncRequest flag and ASyncWait method in script #### Database Build, Export and Management - [Export with data audit](/v1/docs/release-note-datajet-v5-18-1#export-with-data-audit) - [Show/Hide table and field settings cascade to all desktop data displays and dialogs](/v1/docs/release-note-datajet-v5-18-1#showhide-table-and-field-settings-cascade-to-all-desktop-data-displays-and-dialogs) - [FIX: Exporting from table with single continuous field](/v1/docs/release-note-datajet-v5-18-1#bug-fixes) - CountDiscrete on continuous fields available from Data Audit - More compact Data Buffers in file Export #### General Desktop UI - [Extension to DataView Template Dialog](/v1/docs/release-note-datajet-v5-18-1#extension-to-dataview-template-dialog) - [Ability to download a dashboard template](/v1/docs/release-note-datajet-v5-18-1#ability-to-download-a-dashboard-template) - [Login screen contains previous realm popup](/v1/docs/release-note-datajet-v5-18-1#login-screen-contains-previous-realm-popup) - [Toggle Date/Size in Remote File Manager display](/v1/docs/release-note-datajet-v5-18-1#toggle-datesize-in-remote-file-manager-display) - [Extensions to Scheme Settings](/v1/docs/release-note-datajet-v5-18-1#extensions-to-scheme-settings) - FIX: Profile, Index Profile "zoom" window - Tooltips for injected tables - Desktop Application Title includes realm name - List View Table Selector displays tables in alphabetical order - Dataset Collection Builder has editable grid instead of list ### Breaking Changes None ### BUG Fixes | FIX: Exporting from table with single continuous field | Exporting from a table with only a single continuous field in it caused errors. This is resolved. | | --- | --- | | FIX: Sorting by processed columns in profile reports | Sorting issues when including totals and processed columns in a profile report have been resolved. | | FIX: QueryMatrix allows post-processing to toggle/on off | Post-Process on/off in the Query Matrix was disabled - this feature is now enabled. | | FIX: Shared script push not updating “last pulled” value that leads to confusing, false warnings. | | ### Known Issues/Constraints - Query Matrix does not retain base dataset when added to a dashboard ### Changes to API Methods | Category | Method | Description | | --- | --- | --- | | Administration | [Backup](/v1/docs/backup) | New Property: - includeProjectMetaData | | Data Model | [InjectTables](/v1/docs/injecttables) | Now supports [“*”] for all | | Tools | [CreatePackage](/v1/docs/createpackage) | New Method - alternative to [Backup](/v1/docs/backup) | | Data Model | [AddJoinLayer](/v1/docs/addjoinlayer) | New Method - adds multiple layers to table joins | | Audit | [Audit](/v1/docs/audit) | New Property: - targetProject | | Data Model | [InjectPackage](/v1/docs/injectpackage) | New Properties: - sourceName - errorOnMissingDataFiles Additional Error Handling: - "Project Not Found" if target project is not found Enhancments - includeProjectMetaData no longer requires a project close and open | | General | [ExecuteStoredScript](/v1/docs/executestoredscript) | New Property: - aSynchRequest | | Tools | [CreatePackage](/v1/docs/createpackage) | New Method - Creates a zip package that can be used to inject shared data definitions into target projects. | | Data Model | [AddJoinLayer](/v1/docs/addjoinlayer) | Adds a join layer on top of an existing join between 2 tables. | | Data Model | [InjectReports](/v1/docs/injectreports) | Injects reports from one project into another. | ### Feature Details #### PROTOTYPE: Support for multiple heirarchical join conditions when linking tables Joins now support ‘Layers’ - Joins can be extended by compounding up to 7 key pairs. - Accessed through the AddJoinLayer API - “Add Layer” button and Layers column added to join window. - New Join analysis Functions. 1. [Count](/v1/docs/count): The number of layers that match for each record. 2. First: The first layer number (1 based) that matches for each record. 3. Raw: Binary value of matching layers (1st layer = bit 0) 4. Score: higher values for best matches. ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1689270217231.png) #### QueryMatrix productivity features The [Query Matrix](/v1/docs/query-matrix) has had various productivity features added: - Row up, Row Down - Column Left, Column Right - Duplicate Column - Auto Row Label Complete - Auto Column Label Complete - Copy & Paste Cell - Clear Cell - Graph and Grid Display Options - Count At Table (right-click column setting applied when column setup is complete) #### QueryMatrix allows post-processing to toggle/on off The Query Matrix report now supports the ability to toggle on and off post-processing ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1689270327628.png) #### Increased layout options for mixed-view reports Mixed View report now have a relative width option. This gives the following layout options: - 1:1 (available in previous versions) - 2:1 (new in this release) - 1:2 (new in this release) Use the relative Width buttons to control the display: ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1689270868640.png) #### Allow fields to be masked in user interface See [SetPII](/v1/docs/setpii) for details. #### Global Templates Templates can now be globally shared by using templatepath=. (See Command Line Options for more information) #### New Function: RPAD [](/v1/docs/rpadabc)[RPAD(A,B,C)](/v1/docs/rpadabc) : Convert any field into a STRING of a defined length, padding with defined characters from the RIGHT. #### Modified Function: DateFromString format can start with # or not Previously [DateFromString](/v1/docs/datefromstring)(A,B) required a # to be present for parameter B #### Project text box added to Script PUSH Editable Project text box added to script push ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1689272890451.png) #### Host name and username added to Script COMMIT User and Hostname are now recorded when a script is committed, and details are visible on Script history tab. ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1689272986173.png) #### Export with data audit Export with optional audit/penetration generated ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1689275067850.png) Download and auto-open export audits ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1689275099920.png) Summary Audit: ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1689275159741.png) Penetration Audit: ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1689275181639.png) #### Show/Hide table and field settings cascade to all desktop data displays and dialogs Show/Hide fields has been extended so that visibility settings apply everywhere across the project (apart from Data Audit, which retains visibility of all data, whether it is hidden or not). The Show/Hide fields dialog has been extended to support: - Filtering - Searching, - Multi-field select and deselect. ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1689275782887.png) #### Extension to DataView Template Dialog The [DataView](/v1/docs/introduction-to-datasets-and-dataviews) templates dialog now supports: - Search - Filter - Multi field select and deselect ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1689279140180.png) #### Ability to download a dashboard template The template assigned to a [dashboard](/v1/docs/dashboard-overview-introduction) can now be viewed by using right-click | [Template](/v1/docs/dashboard-overview-interacting-with-dashboards) | Download: ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1689275280634.png) #### Login screen contains previous realm popup ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1689279074377.png) #### Toggle Date/Size in Remote File Manager display Turn on and off File Date and Size in the [Remote File Manager](/v1/docs/remote-file-manager) ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1689278944540.png) #### Extensions to Scheme Settings Added Scheme settings - Alternation Off: turns off alternate row colours on grid. - Hide Headers: hides grid headers - No Row Marker: turn off grid row markers - Grid Lines: None, Both, Horizontal or Vertical - Grid Style: Choose style of grid from predefined list. ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1689278783182.png)