Document toolboxDocument toolbox

(v1) .Release Notes v2024.2

Owned by David Engblom
Apr 16, 2024
2 min read


Release 2023.1 is now available; it is a major release that contains new features and refinements. 


NOTE: PHP 8.1 IS REQUIRED for this upgrade.


We will begin scheduling 2023.1 updates on customer Test systems starting on November 4th, 2023.

Notable Changes

Please review the Database Changes in 2023.1 and make any necessary changes to your AdHoc Grids, Custom Events, and API calls.

Review and Refresh Session(s)

We are planning two Review and Refresh sessions for 2023.1. The first session is scheduled for October 24th, 2023, at 11:00 AM Eastern, and the second is scheduled for October 246h, 2023, at 3:00 PM Eastern. 

Key

Release 2023.1 (10-13-2023)

Component

Description

Type

Incident(s)

Documentation

API









Calls & Rating






CustomerCenter






 




General

























Imports & Exports










Inventory






People




Services










Service Desk

















* Indicates external documentation not written by PCR.



Database Changes in 2023.1


Default Schema


Table NameChangeTable Changes
CC_APPROVAL_CRITERIA
Updated
ALTER TABLE `CC_APPROVAL_CRITERIA` ADD `TIER` INT DEFAULT 1 NOT NULL;
ALTER TABLE `CC_APPROVAL_CRITERIA` ADD `HASH` VARCHAR(32);
ALTER TABLE `CC_APPROVAL_CRITERIA` MODIFY COLUMN `HASH` VARCHAR(32) NOT NULL;
ALTER TABLE `CC_APPROVAL_CRITERIA` ADD UNIQUE INDEX `CC_APPROVAL_CRITERIA_6` (`HASH`);
CC_APPROVAL_APPROVERS
Updated
ALTER TABLE `CC_APPROVAL_APPROVERS` ADD `NOTIFY` TINYINT DEFAULT 1 NOT NULL;
CONTACTS_GLA_APPROVAL
Dropped 
IMPORT_FORMAT_REMARKS
New
IMPORT_FORMAT_ATTACHMENTS
New
NOTIFICATIONS
UpdatedAdded a new notification for CustomerCenter Updates
PHONE_SERVICES
Updated
ALTER TABLE `PHONE_SERVICES` DROP FOREIGN KEY `PHONE_SERVICES_2_FK`;
DROP INDEX `PHONE_SERVICES_2` ON `PHONE_SERVICES`;
ALTER TABLE `PHONE_SERVICES` DROP COLUMN `AVAILABLE_SERVICE_HOSTS_RECID`;
SERVICE_DESK_APPROVAL
Dropped 
SERVICE_DESK_APPROVERS
Dropped 
USERS_PERSPECTIVES_ROLES
New
USERS_PERSPECTIVES
Updated
ALTER TABLE USERS_PERSPECTIVES
    ADD PRIORITY INT DEFAULT 0 NOT NULL;

Metadata Schema


Table NameChangeTable Changes
No changes


Archive Schema


Table NameChangeTable Changes
No changes


Supported Versions

Help Desk Portal - Email: help@pcr.com - Phone: 616.259.9242