Release 20212023.3 1 is now available; it is aminor major release that contains new features , bug fixes, and refinements.
NOTE:PHP 8.1 IS REQUIRED for this upgrade.
We will begin scheduling 20212023.3 1 updates on customer Test systems starting , January on November 4th, 20222023.
NOTE: PHP 7.4 IS REQUIRED for this upgrade.
Notable Changes
- Updates native password hashing to increase security
- Adds new password hashing
- Adds manual password expiration to the Users form, and includes a password reset link on the confirmation message
- Retains legacy hashing to identify old passwords
- Expires all user passwords so they are forced to be reset using the new hash
- Note: After the upgrade, all users using the native PCR-360 log-in will have to reset their passwords, this will not affect Shibboleth customers.
- Adds functionality to reset expired passwords after logging in with them
Added two new cleanup Events:
- Cleans up old Bulk Update History records. (The default timeframe is 365 days)
- Cleans up old System Message records. (The default timeframe is 365 days)
- Cleans up old Bulk Update History records. (The default timeframe is 365 days)
Perspectives Grid Changes
- Admins now have the ability to override the PCR grid defaults (i.e. Perspective Admin Defaults).
- Admins may now schedule grid reports from the Perspectives Grid Page.
- Adds support for NENA 3 compatible E911 Reports.
Notable Changes
- PHP 8.1 Required
- Note: PHP 8.1 contains major changes to PHP. PCR recommends thoroughly testing PHP 8.1 and PCR-360 on your test system before installing PHP 8.1 on a production system
Please review the Database Changes in 20212023.31 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 20212023.31. The first session is scheduled for January 12th <insert date> at 11:00 AM Eastern, and the second is scheduled for January 13th <insert date> at 3:00 PM Eastern.
Key
Toggle cloak |
---|
Cloak | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Release
...
2023.
...
1 (
...
10-
...
15-
...
2023)
Component | Description | Type | Incident(s) | Documentation |
---|---|---|---|---|
API | Added |
- The API now verifies a Service is billable when adding a Charge
- The Owner is required for a new GLA Charge
- The Override GLA format is validated against the Owner Billing Group GLA format
- Standardize the parameter charge_catalog_recid for the charge catalog, charge_recid and catalog will still be accepted
- Prorate may be set only if the BILL_MRC_CHANGE_FORCE_PRORATE config option is set to false
- The API now validates whole and fractional quantities for Charges
- An error is thrown if:
- The amount is provided and the Catalog does not allow overrides
- A quantity is provided for a Catalog that does not allow a quantity. (The Quantity is only allowed if the Catalog allows a quantity.)
- The item does not have a Default Expense GLA
Cleaned up a number of notices in the Purchase Order and Barcode API calls:
Catalogs
General
Added two new cleanup Events:
- Cleans up old Bulk Update History records. (The default timeframe is 365 days)
- Cleans up old System Message records. (The default timeframe is 365 days)
Perspectives Grid Changes
- Admins now have the ability to override the PCR grid defaults (i.e. Perspective Admin Defaults).
- Admins may now schedule grid reports from the Perspectives Grid Page.
- Adds new password hashing
- Adds manual password expiration to the Users form, and includes a password reset link on the confirmation message
- Retains legacy hashing to identify old passwords
- Expires all user passwords so they are forced to be reset using the new hash
- Note: After the upgrade, all users using the native PCR-360 log-in will have to reset their passwords, this will not affect Shibboleth customers.
- Adds functionality to reset expired passwords after logging in with them'
Adding a new widget to the dashboard no longer removes existing widgets from the dashboard.
IN-6659
IN-4951
IN-7114
Searching on a date column in Oracle, with certain query strings, no longer throws an error.
Form Perspectives now save content for text editor fields (i.e. the Description text editor on Catalogs).
Imports & Exports
Charge Catalog Import changes:
- The Import now supports Remarks and Remark Author.
- The Import now saves the correct value when USE_QUANTITY is set to Disabled
- The Import no longer blanks out the Amount for Default Charges on existing Equipment Catalogs.
Inactive GLAs can now be used with the following imports:
- Department GLA Permissions
- Contact GLA Permissions
- Contact GLA Approvals
Inventory
Reports
Services
Service Desk
Charges with Billing Group Pricing are now properly updated when the owner of an Action is changed.
Completing a Move Action for a Multi-Location Service no longer throws an error when a "To Location" is not specified.
...
expense_type parameter to Service Desk Equipment post requests. | IN-8817 | Service Desk API Calls | ||
Fixes issues with Completing Service Desk items via the API. | Service Desk API Calls | |||
Calls & Rating | Added ability to update Call Statuses between Raw, Rated, and Rated Unbillable. | IN-8905 | Call Details | |
CustomerCenter | The CustomerCenter Request Tracking page now allows the Requestor to request an update on an item's status. | Users Group 2022 | Request Tracking | |
CustomerCenter Approvals Phase 2
| Users Group 2019 (approval queues, tiered approvals) Users Group 2022 IN-9348 | |||
General | Optimized the temp file cleanup process. | |||
Admin Default Perspectives can now be restricted by User Roles. | Perspectives Grid | |||
Implemented Composer package management to improve the installation and upgrade process. | Installing PCR-360 | |||
Updated the "Get Total Rows" icon with a more meaningful image. | ||||
Adds the ability to edit the page number under any Grid. | IN-7123 IN-3538 IN-4930 | Grid Toolbar | ||
Prevent using Multipart Email MIME type when no attachments are included in Emails. | ||||
Imports & Exports | Added the ability to export and import the Import Formats. | |||
Added a Service Order Equipment Import. | ||||
Inventory | Barcode Transactions can now be sent through the API in batches. | |||
People | Added the ability to Bulk Update Contacts and Departments. | Users Group 2019 | ||
Services | Added Phone and Email Address columns to the Contacts Tab on Services. | IN-8047 | Service Contacts Tab | |
Removed the "Available Service Host" field from Services. This addresses multiple issues related to having two different Service Host values on a Service Record and should alleviate any confusion related to selecting the Service Host on a Service. | IN-6740 IN-9178 IN-9813 | |||
Service Desk | Moved logic specific to the 360 Service Desk Wizard from the Location picker class to its own class. | Converting SD Type | ||
Converting Service Requests to Service Orders now displays a new dialog allowing the selection of SDCs to be applied to each Action on the Order. | ||||
Fixed the Replaced Equipment Picker on the Service Desk Equipment form so you can now select the Equipment on an Incident and its children as being replaced. | IN-3206 | Service Desk Equipment | ||
Fixed the Activity Log displaying the wrong value of returned Equipment when multiple has_unit equipment records are being picked up. | IN-2985 IN-2950 |
* Indicates external documentation not written by PCR.
Anchor | ||
---|---|---|
|
...
|
...
|
...
|
...
|
...
2023.
...
1
Default Schema
Table Name | Change | Table Changes | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
EVENTS | Updated | Added two new events. | ||||||||||
CC_APPROVAL_CRITERIA | Updated | ADDALTER | `IMPORTED_BY` VARCHAR(20) NULL||||||||||
IMPORT_RECORD_TYPES_COLS | Updated | Updated data. | ||||||||||
TENANTS | Updated | ADD `BULK_UPDATE_HISTORY_DAYS`TABLE `CC_APPROVAL_CRITERIA` ADD `TIER` INT DEFAULT | 3651 NOT NULL; | `MESSAGE_DAYS` INT DEFAULT 365 NULLUSERS | Updated | CHANGE COLUMN `PASSWORD` `PASSWORD` VARCHAR(255`HASH` VARCHAR(32); | COLLATETABLE | 'utf8`CC_ | general_ci'APPROVAL_CRITERIA` ADD | COLUMN `PASSWORD_EXPIRED` TINYINT(1) NOT NULL DEFAULT 1USERS_PASSWORDS | Updated | Reset the password for all users.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 | Updated | Added a new notification for CustomerCenter Updates | ||||||||||
PHONE_SERVICES | Updated | ALTER TABLE `PHONE_SERVICES` DROP FOREIGN KEY `PHONE_SERVICES_2_FK`; | ||||||||||
SERVICE_DESK_APPROVAL | Dropped | |||||||||||
SERVICE_DESK_APPROVERS | Dropped | |||||||||||
USERS_PERSPECTIVES_ROLES | New | |||||||||||
USERS_PERSPECTIVES | Updated | ALTER TABLE | `USERS_PERSPECTIVES` MODIFY `USERS_RECID`USERS_PERSPECTIVES |
Metadata Schema
Table Name | Change | Table Changes |
---|---|---|
No changes |
...
Table Name | Change | Table Changes |
---|---|---|
No Changeschanges |