2.15.0 - Data Pull, Orders, and Variance

September 25, 2024

New Features

Data Pull

  • Added an integration type for deleting Orders based on status. This includes the new functionality for mapping and conditionally deleting Orders, the introduction of a new drop down for selecting Order creation or deletion types, and improved settings visibility based on the selected type.
  • The Order deletion integration type will return an API call confirming the deletion.
  • Added a "No Structure" option in the settings for data mappings, allowing users to select a flat mapping configuration. This will flatten nested structures, bring all fields to the same level.

Orders

  • Enhanced the Order interface in Explorer to provide a clearer representation of Order timelines (using the modifiedDate field instead of createdDate).
  • Updated the Descriptions section to accept more complex content types, allowing for richer data display.

Time zones

  • Enhanced the user experience in forms by allowing the timeZone field to be optional.
  • Implemented dynamic time zone retrieval for user forms, pre-filling the time zone based on the user's system settings.
  • Added functionality to clear time zone selections in forms.

Variance

  • Introduced new grouping and filtering capabilities in reports, allowing users to specify additional grouping columns and filter groups.
  • Added support for enhanced join conditions (allowing for OR joins). 
  • Introduced a new caching mechanism for managing integration jobs, including support for triggers in the integration component and a scheduling option for integration tasks every 20 seconds.
  • Added an "advanced" mapping type option in the Mapping component.
  • Introduced new comparison operators for filters in the variance report, allowing for "starts with", "ends with", and "includes" filtering.

Bug Fixes

General

  • References to stale data would cause issues during report deletion, the report deletion function was modified to resolve this issue.
  • If a user uses the back button in their browser from the 404 page, they would be redirected to the 404 page a second time.  The back button will take users back one additional step in their browser history, preventing the redirect from occurring.
  • Orders would display incorrect dates, adjusted which field was used to display the Creation Date to ensure accurate data is displayed to users.

Data Pull

  • Improved response messages when running data pull order deletion, adding a success indicator for deletion operations in the output results.
  • Resolved an issue when flattening material data using material data would not be applied by enhancing the data processing logic.

Variance

  • Resolved an issue where Left, Right and Outer join conditions were not properly joining tables.
  • Filters on Variance report columns would not be applied if there is no data that can be joined. This was resolved by adding a step to collect all Variance columns, adjusting the filtering accordingly.

Patch 2.15.0.2

Bug Fixes

  • Token based authentication would not properly refresh if the Last Updated column is empty, the internal calculation for refresh periods was improved to resolve this issue.

Patch 2.15.0.1

  • New comparison operators are available in reports:
    • Sum
    • Ratio
    • Percentage
    • Modulus (yields the remainder)
    • Product