2.19.0 - Power Pick Oracle Database Connections

March 21, 2025

New Features

Kardex connections

  • ItemPath now supports connections to Power Pick Oracle databases, in addition to MSSQL databases. Connecting to a Power Pick Oracle database requires the following, similar to connecting to an MSSQL database:
    • Database address (URL or IP) and port
    • Database name
    • User name and password (the user should have equivalent permissions to the  db_owner role, but permissions can be more restrictive if ItemPath won't create or delete records)
  • Updated the Kardex page in Settings  to reflect that ItemPath can connect to multiple Power Pick Database types.

Workflow logs

  • The status column, which indicates workflow action success, now includes a column header.

Other

  • When filtering on UUID column types, only the "Is" and "Not" operators are available.

Bug Fixes

  • Corrected the password reset link in the "Welcome to ItemPath" email.
  • Fixed an error that occurred when passing status=processed to GET /orders (i.e., GET /orders?status=processed).
  • Fixed an issue where History Order Line reports displayed incorrect data when Order table columns were included.