Version 2.5.44

Added

• Added user_settings table
• Added dialTimezone and utcOffset columns in cm_contacts table
• Added dialTimezone column in cm_hopper table
• Added dialTimezone column in cm_hopper_history table
• Added CloudProviderId and modernAuthentication columns in int_dynamics365_accounts table

Version 2.5.42

18 Dec 2021 

Added

• Added plainBody column in chat_offline_messages table

Version 2.5.41

13 Dec 2021 

Added

• Added limitTabs, disabledCookies, previewRecallmeReminderInterval columns in settings table
• Added recallmeNotifiedDate column in cm_hopper table
• Added dialPreviewRecallmeReminder column in voice_queues table
• Added type, data3, data4, data5, data6, data7 column in cloud_providers table
• Added provider column in mail_accounts table
• Added modenAuthentication, CloudProviderId in mail_server_in table
• Added modenAuthentication, CloudProviderId in mail_server_out table

Changed

• Updated service column in cloud_providers table

API Changes

Version 2.5.39

29 Nov 2021 

Added

• Added adSsoEnabled column in settings table
• Added adSsoEnabled column in users table
• Added labelText column in chat_websites table
• Added moduleCreate column in int_dynamics365_configurations table

API Changes

• Added /api/auth/activedirectory endpoint

Version 2.5.37

12 Nov 2021 

Added

• Added viewHelpSection and secureCookieEnabled columns in settings table
• Added baseUrl and type columns in whatsapp_accounts table
• Added user_settings table

API Changes

• Added /api/realtime/agents endpoint
• Added /api/user-settings endpoints

Version 2.5.36

12 Oct 2021 

Added

• Added ignorePauseForPreviewCalls and selectRecallMeCampaign columns in users table
• Added dialPreviewAutoRecallMe column in voice_queues table

Version 2.5.35

26 Sep 2021 

Added

• Added team_has_voice_prefixes table

Version 2.5.33

24 Aug 2021 

Added

• Added alias column in voice_extensions table

Changed

• Updated charset and collate for cm_contacts and openchannel_interactions tables
• Updated tools_dispositions_ibfk_1, tools_dispositions_ibfk_2, tools_dispositions_ibfk_3, tools_dispositions_ibfk_4, tools_dispositions_ibfk_5, tools_dispositions_ibfk_6, tools_dispositions_ibfk_7 constraints for tools_dispositions table

API Changes

• Updated /api/voice/extensions methods

Version 2.5.32

09 Aug 2021 

Added

• Added autoreplyExecuted in mail_interactions, chat_interactions, openchannel_interactions, sms_interactions and whatsapp_interactions tables

API Changes

• Added /api/realtime/queues method

Version 2.5.31

10 Jul 2021 

Added

• Added vidaooTopic, vidaooNote and vidaooMetadata in chat_websites table

API Changes

• Updated /api/chat/interactions/{id}/vidaoo endpoint

Version 2.5.30

16 Jun 2021 

Added

• Added downloadAttachments, downloadOmnichannelInteractions and downloadVoiceRecordings columns in users table
• Added downloadAttachments, downloadCallySquareRecordings, downloadContactManagerLists, downloadJscriptySessions, downloadOmnichannelInteraction, downloadScreenRecordings and downloadVoiceRecordings columns in user_profiles table

Changed

• Changed previousPasswords column in users table

Version 2.5.28

15 May 2021 

API Changes

• Updated /api/userProfiles/{id}/resources endpoint

Version 2.5.26

07 May 2021 

Added

• Added ChatOfflineMessageId column in attachments table
• Added subjectOffline column in chat_websites table

API Changes

• Updated /api/users and /api/users/{id} endpoints

Version 2.5.25

25 Apr 2021 

Added

• Added stopRecordingOnTransfer column in settings table

API Changes

• Added /api/users/{id}/open_tabs endpoint
• Updated /api/users and /api/users/{id} endpoints

Version 2.5.23

03 Apr 2021 

Added

• Added leadIId column in int_salesforce_configurations table
• Added privacyPolicyNumber, privacyPolicyEmail and privacyPolicyName columns in settings table
• Added privacyEnabled column in user_profiles table
• Added additionalSearchAccount, additionalSearchContact and additionalSearchLead columns in int_salesforce_configurations table

Changed

• Changed type column in int_desk_fields table
• Changed type column in int_dynamics365_fields table
• Changed type column in int_freshdesk_fields table
• Changed type column in int_freshsales_fields table
• Changed type column in int_salesforce_fields table
• Changed type column in int_servicenow_fields table
• Changed type column in int_sugarcrm_fields table
• Changed type column in int_vtiger_fields table
• Changed type column in int_zendesk_fields table
• Changed type column in int_zoho_fields table
• Changed moduleSearch column in int_salesforce_configurations table
• Changed moduleCreate column in int_salesforce_configurations table

Deprecated

• lastMsgBody and lastMsgText columns in mail_interactions table are deprecated

Version 2.5.22

21 Mar 2021 

Added

• Added openNewInteraction and MailAccountId columns in chat_websites table
• Added ChatWebsiteId, originChannel and ChatOfflineMessageId columns in mail_messages table

Changed

• Changed stamp column in voice_voicemail_messages table

Version 2.5.21

12 Mar 2021 

Added

• Added penalty column in team_has_voice_queues table

API Changes

• Added /api/users/presence endpoint

Version 2.5.20

03 Mar 2021 

Added

• Added userNotifications table
• Added titleFontSize column in dashboard_items table

API Changes

• Added /api/userNotifications endpoint

Version 2.5.18

23 Feb 2021 

Added

• Added chatInteractionsReloadTimeout, mailInteractionsReloadTimeout, openchannelInteractionsReloadTimeout, smsInteractionsReloadTimeout and whatsappInteractionsReloadTimeout columns in settings table

Version 2.5.16

05 Feb 2021 

Changed

• Changed type column in sms_accounts table

Added

• Added accountId and applicationId columns in sms_accounts table

Version 2.5.15

31 Jan 2021 

Changed

• Changed question column in report_jscripty_answers table
• Changed question column in report_jscripty_questions table

Version 2.5.14

27 Jan 2021 

API Changes

• Added /api/cm/contacts/{id}/journey method

Version 2.5.12

16 Jan 2021 

Changed

• Changed serverUrl column in int_desk_accounts table
• Changed serverUrl column in int_dynamics365_accounts table
• Changed serverUrl column in int_freshdesk_accounts table
• Changed serverUrl column in int_freshsales_accounts table
• Changed serverUrl column in int_salesforce_accounts table
• Changed serverUrl column in int_servicenow_accounts table
• Changed serverUrl column in int_sugarcrm_accounts table
• Changed serverUrl column in int_vtiger_accounts table
• Changed serverUrl column in int_zendesk_accounts table
• Changed serverUrl column in int_zoho_accounts table

Version 2.5.11

02 Jan 2021 

Added

• Added searchOnEnterKey column for settings table

Version 2.5.10

21 Dec 2020 

Added

• Added savedAt and publishedAt columns for square_projects table

Version 2.5.7

17 Nov 2020 

Added

• Added providerName and providerResponse columns for chat_messages table
• Added providerName and providerResponse columns for openchannel_messages table
• Added providerName and providerResponse columns for sms_messages table
• Added providerName and providerResponse columns for square_messages table
• Added providerName and providerResponse columns for whatsapp_messages table

API Changes

• Added /api/settings/now method

Version 2.5.6

04 Nov 2020 

Added

• Added missed FULLTEXT index for cm_contacts table

API Changes

• Updated /api/openchannel/interactions/{id} method
• Added /api/rpc/openchannel/queues/{{id}}/waitinginteractions method

Version 2.5.5

26 Oct 2020 

Added

• Added enforcePasswordHistory, passwordHistoryLimit columns in settings table
• Added previousPasswords, settingsEnabled column in users table
• Added clickToAction, actionType columns in cm_custom_fields table
• Added level, description, ParentId columns in tools_dispositions table
• Added userSecondDisposition, userThirdDisposition columns in report_call table
• Added secondDisposition, thirdDisposition columns in report_queue table
• Added userSecondDisposition, userThirdDisposition columns in voice_recordings table
• Added secondDisposition, thirdDisposition columns in chat_interactions table
• Added secondDisposition, thirdDisposition columns in fax_interactions table
• Added secondDisposition, thirdDisposition columns in report_queue table
• Added secondDisposition, thirdDisposition columns in mail_interactions table
• Added secondDisposition, thirdDisposition columns in openchannel_interactions table
• Added secondDisposition, thirdDisposition columns in sms_interactions table
• Added secondDisposition, thirdDisposition columns in whatsapp_interactions table
• Added secondDisposition, thirdDisposition columns in cm_hopper_final table

Version 2.5.2

02 Sep 2020 

Added

• Added dialNoSuchNumberMaxRetry, dialNoSuchNumberRetryFrequency, dialDropMaxRetry, dialDropRetryFrequency, dialAbandonedMaxRetry, dialAbandonedRetryFrequency, dialMachineMaxRetry, dialMachineRetryFrequency, dialAgentRejectMaxRetry, dialAgentRejectRetryFrequency columns in voice_queues table
• Added dialNoSuchNumberMaxRetry, dialNoSuchNumberRetryFrequency, dialDropMaxRetry, dialDropRetryFrequency, dialAbandonedMaxRetry, dialAbandonedRetryFrequency, dialMachineMaxRetry, dialMachineRetryFrequency, dialAgentRejectMaxRetry, dialAgentRejectRetryFrequency columns in campaigns table
• Added countnosuchnumberretry, countdropretry, countabandonedretry, countmachineretry, countagentrejectretry column in cm_hopper table
• Added countnosuchnumberretry, countdropretry, countabandonedretry, countmachineretry, countagentrejectretry column in cm_hopper_history table
• Added countnosuchnumberretry, countdropretry, countabandonedretry, countmachineretry, countagentrejectretry column in cm_hopper_final table

Changed

• Added encryption option for whatsapp_accounts, whatsapp_interactions, whatsapp_messages, report_whatsapp_queue and cloud_providers tables
• Updated voice_extensions_ibfk_7 constraint for voice_extensions table

Version 2.5.0

18 Aug 2020 

Added

• Added vidaooSessionId column in chat_interactions table
• Added vidaooEscalation and vidaooApiKey columns in chat_websites table
• Added tables (whatsapp_accounts, whatsapp_applications, whatsapp_interactions, whatsapp_messages, whatsapp_queues, report_whatsapp_queue and report_whatsapp_transfer) for WhatsApp Connector channel
• Added whatsappPause and whatsappCapacity in users table
• Added notifications table
• Added cloud_providers table
• Added transcribe, automaticTranscribe, transcribeAccountId, transcribeRegion, sentiment, automaticSentiment, sentimentAccountId, sentimentRegion, language. bucket columns in settings table
• Added location, transcribeName, transcribeStatus, fileUri, fileText, failureReason, sentiment, sPositive, sNegative, sNeutral, sMixed, tempSentiment columns in voice_recordings table

API Changes

• Added /api/notifications endpoint
• Added /api/voice/recordings/:id/transcribe endpoint

• Added /api/chat/interactions/:id/vidaoo endpoint

• Added /api/cloudProviders endpoints
• Added endpoints for WhatsApp Connector channel

Version 2.4.20

01 Jul 2020 

Added

• Added googleSsoEnabled column in settings table

API Changes

• Added /api/webbar endpoints

Version 2.4.19

14 Jun 2020 

Added

• Added moduleSearch column in int_zoho_configurations table
• Added username and password columns in network table

Changed

• Changed moduleCreate column in int_zoho_configurations table
• Changed type for type column in network table

Version 2.4.18

09 Jun 2020 

Updated

• Updated joinempty and leavewhenempty properties for voice_queues table (apply default value for empty columns)

Version 2.4.16

16 May 2020 

Added

• Added FULLTEXT index for cm_contacts table

Version 2.4.14

20 Apr 2020 

Added

• Added int_freshsales_accounts, int_freshsales_configurations and int_freshsales_fields tables

Version 2.4.13

09 Apr 2020

Added

• Added sendUnpauseOnSubmit columns in jscripty_projects table

Version 2.4.10

10 Mar 2020

Added

• Added favicon, defaultFavicon columns in settings table

Changed

• Changed type for referer column in chat_interactions table

Version 2.4.7

21 Feb 2020

Added

• Added customerPort column in chat_interactions table
• Added enableSendButton column in chat_websites table
• Added feedbackTitle column in chat_websites table
• Added moduleCreate column in int_zoho_configurations table

Version 2.4.4

28 Jan 2020

Added

• Added zone, clientId, clientSecret, code and refreshToken columns in int_zoho_accounts table

Removed

• Removed authToken column in int_zoho_accounts table

Version 2.4.2

12 Jan 2020

Added

• Added allowedLoginAttempts and blockDuration columns in settings table
• Added blocked, blockedAt, disabled and loginAttempts columns in users table

Changed

• Added encryption option for screen_recordings table

Version 2.4.0

20 Dec 2019

Added

• Added phoneBarEnableAutomaticScreenRecording and screenrecording columns in users table
• Added lastMsgText column in mail_interactions table
• Added plainBody column in mail_messages table
• Added FULLTEXT index for chat_messages table
• Added FULLTEXT index for mail_interactions table
• Added FULLTEXT index for mail_messages table
• Added FULLTEXT index for openchannel_messages table
• Added FULLTEXT index for sms_messages table
• Added screen_recordings table

Changed

• Renamed phoneBarEnableVideoRecording column to phoneBarEnableScreenRecordingByAgent
• Changed charset type for chat_applications table
• Changed charset type for fax_applications table
• Changed charset type for mail_applications table
• Changed charset type for openchannel_applications table
• Changed charset type for sms_applications table

Version 2.3.97

01 Dec 2019

Added

• Added id, createdAt, updatedAt columns in migrations table
• Added UNIQUE key to column version in migrations table
• Added dialPredictiveIntervalMaxThreshold and dialPredictiveIntervalMinThreshold columns in voice_queues table
• Added option to disable the xdr service for voice analytics 

Changed

• Removed PK and AUTO_INCREMENT properties from column version in migrations table

API Changes

• Changed response body for /api/version/migrations endpoint (added list of executed migrations and updated output message)

Version 2.3.96

21 Nov 2019

Added

• Added column defaultScreenRecordingPath in settings table

API Changes

• Removed property realtime from api/voice/queues/{id}/users endpoints

Version 2.3.10

10 Nov 2019

Added

• Added column sipcallid in report_call table

Version 2.3.7

21 Oct 2019

Added

• Added column transfer in report_agent table
• Added column transfertype in report_agent table
• Added column transferexten in report_agent table
• Added column transferuniqueid in report_agent table
• Added column agententerreason in report_agent table
• Added column systemanswertime in report_call table
• Added column ticketType in int_salesforce_configurations table

Version 2.3.3

20 Sep 2019

Changed

• Changed charset type for tools_canned_asnwers table
• Changed datatype for appdata column in chat_applications table
• Changed datatype for appdata column in fax_applications table
• Changed datatype for appdata column in mail_applications table
• Changed datatype for appdata column in openchannel_applications table
• Changed datatype for appdata column in sms_applications table

Version 2.3.2

12 Sep 2019

Added

• Added column rltSupport in settings table

Changed

• Added encryption option for int_dynamics365_accounts table
• Added encryption option for int_servicenow_accounts table

Version 2.3.0

04 Sep 2019

Added

• Added column apiKeyNonce in users table
• Added column apiKeyIat in users table
• Added index on column uniqueid in report_call table

Version 2.2.6

30 Aug 2019

Changed

• Changed charset type for mail_interaction table

Added

• Added mandatoryDisposition and mandatoryDispositionPauseId column in voice_queues table
• Added mandatoryDisposition and mandatoryDispositionPauseId column in mail_accounts table
• Added mandatoryDisposition and mandatoryDispositionPauseId column in chat_websites table
• Added mandatoryDisposition and mandatoryDispositionPauseId column in sms_accounts table
• Added mandatoryDisposition and mandatoryDispositionPauseId column in openchannel_accounts table
• Added mandatoryDisposition and mandatoryDispositionPauseId column in fax_accounts table

Version 2.2.4

13 Aug 2019

Added

• Added unique index in int_desk_fields table
• Added unique index in int_freshdesk_fields table
• Added unique index in int_salesforce_fields table
• Added unique index in int_sugarcrm_fields table
• Added unique index in int_vtiger_fields table
• Added unique index in int_zendesk_fields table
• Added unique index in int_zoho_fields table

Version 2.2.3

09 Aug 2019

Changed

• Changes size for inReplyTo column in mail_interactions table
• Changes size for messageId column in mail_messages table

Version 2.2.0

25 Jul 2019

Changed

• Changed default value for phoneBarListenPort column
• Updated column type in sms_accounts table

Version 2.1.0

23 Jul 2019

Added

• Added column reportId in analytics_extracted_reports table
• Added column reportType in analytics_extracted_reports table
• Added column userProfileId in users table
• Added user_profiles table
• Added user_profile_has_sections table
• Added user_profile_has_resources table
• Added column apiKey in sms_account table

Version 2.0.84

04 Jul 2019

Security

• Added redis connection configuration (handle authentication)

Version 2.0.83

21 Jun 2019

Added

• Added column OwnerId in cm_hopper table
• Added column fb_data in cm_contacts table
• Added column baseUrl in sms_accounts table
• Added column queuecallerenterreason in report_queue table

Changed

• Updated column type in sms_accounts table

Security

• Added redis connection configuration (no authentication)
• Applied restriction on listening IP address and TCP port for Cally Square service

Version 2.0.82

06 Jun 2019

Added

• Added column apiKey in sms_account table

Changed

• Updated column type in sms_accounts table

Version 2.0.81

17 May 2019

Added

• Added column telegram in cm_contacts table

Changed

• Updated column smsMethod in sms_accounts table

Version 2.0.77

19 Apr 2019

Added

• Added column preferred in settings table
• Added column defaultPreferred in settings table

Version 2.0.78

21 Mar 2019

Changed

• Added encryption option for square_messages table

Version 2.0.77

07 Mar 2019

Added

• Added bot column in report_square table
• Added interface column in users table
• Added privacyEnabled column in users table
• Added square_messages table

Version 2.0.76

21 Feb 2019

Added

• Added hotdesk column in users table

Changed

• Added encryption option for report_<channel>_transfer tables

Removed

• Emptied sessions table

Version 2.0.73

30 Jan 2019

Added

• Added routeid column in report_call table
• Added originatecalleridnum column in cm_hopper_final table
• Added originatecalleridname column in cm_hopper_final table
• Added originatecalleridnum column in cm_hopper_history table
• Added originatecalleridname column in cm_hopper_history table
• Added wechat column in cm_contacts table
• Added fb_data column in cm_contacts table

Version 2.0.72

10 Jan 2019

Added

• Added uid_pname index in report_square table
• Added leaveAt index in report_square table

Version 2.0.71

20 Dec 2018

Added

• Added queueTransfer, queueTransferTimeout, agentTransfer, agentTransferTimeout columns in chat_websites table
• Added queueTransfer, queueTransferTimeout, agentTransfer, agentTransferTimeout columns in fax_accounts table
• Added queueTransfer, queueTransferTimeout, agentTransfer, agentTransferTimeout columns in openchannel_accounts table
• Added queueTransfer, queueTransferTimeout, agentTransfer, agentTransferTimeout columns in sms_accountstable
• Added enableCustomerCheckmarks column in chat_websites table
• Added systemAlias column in chat_websites table
• Added systemAvatar column in chat_websites table
• Added chatTimeout column in settings table
• Added phoneBarRememberMeEnabled column in settings table
• Added chatLicenseExceeded column in license table
• Added data7 column in tools_actions table

Logs

• Added auth-info log file

Version 2.0.70

04 Dec 2018

Added

• Added mohtime column in report_call table
• Added mohtime column in report_queue table

Changed

• Added encryption option for int_vtiger_accounts table

Version 2.0.69

15 Nov 2018

API Changes

• Added associated queue in /api/chat/internal/messages/users
• Added /api/chat/interactions/{id}/custom_update endpoint
• Updated /api/voice/prefixes endpoints (POST, PUT methods)
• Added agent status (online/offline) in /api/auth/local endpoint
• Added /api/rpc/{voice|mail|chat|fax|openchannel|sms}/queues/{id} endpoints
• Added deadline and grayReason properties in /api/license endpoint

Socket event changes

• Improved {voice|chat|fax|mail|sms|openchannel}_queue:save events
• Improved user:save event
• Improved mailAccount:save event

Added

• Added messageFontSize column in chat_websites table
• Added backgroudColor column in chat_websites table
• Added line column in cm_contacts table
• Added callerIdAll column in voice_prefixes table
• Added VoiceExtensionId column in voice_prefixes table
• Added VoicePrefixId column in voice_extensions table
• Added relationship between voice_extensions and voice_prefixes tables
• Added prefix column in report_call table
• Added unique index for name column in tools_sounds table
• Added int_vtiger_accounts, int_vtiger_configurations, int_vtiger_configuration_has_tags and int_vtiger_fields tables

Changed

• Changed type for answer column in report_jscripty_answers table
• Changed type for answer column in report_jscripty_questions table
• Added unique constraint for name column in tools_sounds table

Removed

• Removed prefix column in voice_prefixes table

Version 2.0.68

17 Oct 2018

API Changes

• Added /api/openchannel/accounts/{id}/send endpoint
• Added /api/trunks/clone endpoint

Added

• Moved static disposition (Fax, Answer Machine, Interested, Not Interested, Sold, Special) as global disposition
• Added mapKey column in openchannel_accounts table
• Added closeReason column in chat_interactions table
• Added messagesAlignment column in settings table

Version 2.0.67

02 Oct 2018

Added

• Added tools_dispositions table
• Added user_has_chat_website table
• Added user_has_mail_account table
• Added user_has_sms_account table
• Added user_has_fax_account table
• Added user_has_openchannel_account table
• Added originTo and originCc columns in mail_messages table

Removed

• Removed chat_dispositions table
• Removed email_dispositions table
• Removed sms_dispositions table
• Removed openchannel_dispositions table
• Removed fax_dispositions table