2.18.0 - Improved Connections, Reporting, and Order Creation

February 11, 2025

2.18.0.0

New Features

New features are available in Connections, Data Pull, Order Builder, Reports, and Variance:

Connections

  • Values for private headers are now hidden with * marks after you enter the header value.

Data Pull

  • You can now set how frequently Data Pull integrations fetch data from external systems. This is currently available as a global setting for the Data Pull app, available in Settings > Apps > Data Pull. By default, Data Pull fetches data every 10 seconds.

Order Builder

  • You can now select the location identification type and add multiple locations based on ID or name.
  • The schema for creating count orders via Order Builder has been expanded: If location data is passed in the order body, order lines are no longer required. Instead, order lines are generated based on the location information passed. ItemPath then creates a line for each location specified.
  • Work orders and work order lines are created as part of this method.

Reports

  • Grouping by date range is now available for Reports. When you select a date column to group by, new input options appear to specify the unit (hours, minutes, etc.). Note that the "floor" time value from the range is used in the resulting rows (for example, "1:00 PM – 1:59 PM" appears as "1:00 PM" in the resulting group row).

Variance

  • The Variance app has been enhanced to better support different connection types:
    • The SQL Table option appears only if the connection is a SQL connection.
    • For REST or GraphQL connections, you can now specify Path (URL path for the endpoint), Verify (whether SSL certificates are enabled), and Timeout (number of seconds before the connection times out) properties.

Bug Fixes

  • Applying a filter to a count column sometimes caused slow report loading times or failed to be applied altogether. This issue has been corrected by adjusting how filters and count columns are applied.
  • Integers produced by count columns included in comparison columns resulted in N/A or blank values. This issue has been corrected by adjusting how Reports handles comparisons and counts.
  • When modifying the headers for a connection, the validation check ran if no values were applied to the text boxes. This has been adjusted so it shows only when you select Create a Header.
  • Cookie-based authentication failed when cookie keys specified in the connection settings didn't match the cookie returned from the external connection. This occurred because of a failure to properly re-fetch cookies after expiration. This was resolved with improved error handling and authentication checks.

Removed Features

  • The Order creation mode in Order Builder is no longer available. Previously, this mode created one order per report row.

2.18.0.1

New Features

  • Data Push now includes a maximum records setting that lets you control the maximum number of records processed per second. This can be helpful when working with larger datasets.
  • Workflow log descriptions now include a report ID (if an event is generated from a report).
  • A database qualifier setting is now available for IBM DB2 connections. This qualifier specifies the database schemas (libraries) to include in the search path for this query.

Bug Fixes

  • When using workflows to send email, an error in action order prevented attachments from being added to the email. By adjusting workflow processing, child actions are now correctly associated with parent workflows, ensuring that attachments are added to the email.