This article provides an overview of changes and additional features in the release of the new version of Puzzel Raw data.
Puzzel plans to upgrade all customers' Raw data SQL databases to the new version during week 8 (February 17th-21st, 2025).
We expect only a few minutes down-time per customer, and the new version is backwards compatible.
The new Raw data version (2.4.1.0) includes:
- 3 new columns in table surveys
- survey_name - nvarchar(50)
- survey_id - uniqueidentifier
- related_ticket_id - nvarchar(50)
For Customer Insight Surveys, survey_name and survey_id will get a value, so that it will be easier to distinguish between different Surveys. related_ticket_id might be populated for Customer Insight Surveys related to Puzzel Case Management Surveys.
If, during week 8, you would like to confirm whether your database is updated or not, you can look for the new columns in table surveys, or use this statement to see the db version:
select convert(varchar(255), value) from ::fn_listextendedproperty('DBVERSION', null, null, null, null, null, null)
The surveys article in the PCC Raw data section on help.puzzel.com is already updated.