Upgrade notes
Schema changes for 21.09
Schema-level changes
New tables
No new tables were provided.
Renamed tables
No tables have been renamed.
Dropped & recreated tables
No tables need to be dropped & recreated.
Removed tables
No tables were removed.
Existing tables affected by DML Upgrade SQL scripts
- NJUserGroupPrivilegeLink
Table-level changes:
There are no table-level changes.
Environment file changes for 21.09
There are no environment file changes.
Data source connections:
No data source connections were added or removed.
Channel connections:
No channel connections were added or removed.
Mixins:
The sso mixin is required to be explicitly set in the environment file for applicable clients. For more information, see Upgrading to NexJ CRM version 21.09.
Schema changes for 9.9
Schema-level changes
New tables
- NJCmpgnParticipationStatus
Renamed tables
No tables have been renamed.
Dropped & recreated tables
No tables need to be dropped & recreated.
Removed tables
No tables were removed.
Existing tables affected by DML Upgrade SQL scripts
Table-level changes:
| Modified Table | New Column | Modified Column | Renamed Column | Removed Column | New Index | Renamed Index | Dropped & Recreated Index | Removed Index |
| NJActTemplate | isTargeted | |||||||
| NJActivityPlanStep | isTargetActivity | |||||||
| NJActivityPlanStep | specificStartTime | |||||||
| NJActivityPlanStep | specificDueTime | |||||||
| NJActivityPlanStep | dateType |
Environment file changes for 9.9
There are no environment file changes.
Data source connections:
No data source connections were added or removed.
Channel connections:
No channel connections were added or removed.
Mixins:
The sso mixin is required to be explicitly set in the environment file for applicable clients. For more information, see Upgrading to NexJ CRM version 21.09.
Schema changes for 9.8
Schema-level changes
New tables
- NJCampaignTeamMember
- NJCPWFTemplate
- NJCPWTPStatusLink
- NJCPWTPStatus
- NJCPWFStatusLink
- NJCPWFStatus
- NJCPWorkflow
- NJCPWFAction
- NJCPWFActText
- NJCPWFATMRole
- NJCPWFAUser
- NJEntityXLead
- NJCPPartTimer
- NJCPWFADoc
NJLoggingConfig
NJNodeXLogging
NJNodeLogRemoval
Renamed tables
No tables have been renamed.
Dropped & recreated tables
No tables need to be dropped & recreated.
Removed tables
No tables were removed.
Existing tables affected by DML Upgrade SQL scripts
- NJImportProcessStage
- NJFilter
- NJActTemplate
- NJUserGroupPrivilegeLink
- NJCampaignTeamMember
- NJCPWTPStatusLink
- NJCPWTPStatus
- NJCPWFTemplate
- NJSystemPreference
- NJUserGroupLink
- NJEntity
- NJUserPerson
- NJUser
- NJPrincipal
- NJLocalUser
- NJUserBase
- NJTypeLocalization
- NJAct
- NJTaskEntity
Table-level changes:
| Modified Table | New Column | Modified Column | Renamed Column | Removed Column | New Index | Renamed Index | Dropped & Recreated Index | Removed Index |
| NJFilter | Filter.OK1 | |||||||
| NJCampaignParticipation | status | |||||||
| NJCampaignParticipation | statusUpdateTime | |||||||
| NJCampaign | stageCode | |||||||
| NJCampaign | Campaign.FK_Stage | |||||||
| NJActX01 | ActX01.FK_Folder | |||||||
| NJLead | expiryDate | |||||||
| NJCPWFAction | assignedUserId | |||||||
| NJCPWFAction | CPWFAction.FK_AssignedUser | |||||||
| NJEntity | doNotContactFlag | |||||||
| NJCPWFAction | emailFrom | |||||||
| NJCPWTPStatus | CPWTPStatus.AK |
Environment file changes for 9.8
The legacyLeadsEnabled flag was added to the environment file. For more information about legacyLeadsEnabled, see Upgrading to NexJ CRM version 9.8.
Data source connections:
No data source connections were added or removed.
Channel connections:
No channel connections were added or removed.
Mixins:
The sso mixin is required to be explicitly set in the environment file for applicable clients. For more information, see Upgrading to NexJ CRM version 9.8.
Schema changes for 9.6
Schema-level changes
New tables
No new tables were provided.
Renamed tables
No tables have been renamed.
Dropped & recreated tables
No tables need to be dropped & recreated.
Removed tables
No tables were removed.
Existing tables affected by DML Upgrade SQL scripts
- NJExchangeServer
Table-level changes:
| Modified Table | New Column | Modified Column | Renamed Column | Removed Column | New Index | Renamed Index | Dropped & Recreated Index | Removed Index |
| RPTExecutedReport (for Reporting only) | isScheduled | |||||||
| RPTReport (for Reporting only) | subjectAreaCaption | |||||||
| RPTScheduledReport (for Reporting only) | classCode | |||||||
| RPTExecutedFiles (for Reporting only) | isScheduled | |||||||
| OpportunityStageTemplate | active | |||||||
| NJExchangeServer | maxErrorCount |
Environment file changes for 9.6
No new flags were added to the environment file.
Data source connections:
No data source connections were added or removed.
Channel connections:
No channel connections were added or removed.
Mixins:
| Added | Removed | Updated minimum version |
| nexj:model:afl | ||
| nexj:model:afl-mda | ||
| nexj:model:portal | ||
| nexj:model:highcharts |
Schema changes for 9.5
Schema-level changes
New tables
No new tables were provided.
Renamed tables
No tables have been renamed.
Dropped & recreated tables
No tables need to be dropped & recreated.
Removed tables
No tables were removed.
Existing tables affected by DML Upgrade SQL scripts
- NJEnumDisplay
Table-level changes:
| Modified Table | New Column | Modified Column | Renamed Column | Removed Column | New Index | Renamed Index | Dropped & Recreated Index | Removed Index |
| NJAct | Act.FK_AccountPlan | |||||||
| NJActSeries | Act.FK_AccountPlan | |||||||
| NJLead (for Reporting only) | rpt_fullName | |||||||
| RPTDashboard (for Reporting only) | isPrivate |
Environment file changes for 9.5
- The following flags were added to the Environment file:
- stuckThreadThreshold
For more information, see Example environment settings for NexJ CRM deployment. - If you are moving to OAuth authentication for Exchange Online, add the
exo.tokenURLproperty to your environment file.
For more information, see Using Microsoft Exchange Online with OAuth authentication.
- stuckThreadThreshold
Data source connections:
No data source connections were added or removed.
Channel connections:
| Added | Removed |
If you are moving to OAuth authentication for Exchange Online, you can configure the ExchangeEWSSender channel. | |
| rptadapter:ReportingInstanceSender HTTPConnection (for Reporting with replicated database only) | |
| bireport:ReportingInstanceSync (for Reporting with replicated database only) |
Mixins:
| Added | Removed | Updated minimum version |
| nexj:model:afl | ||
| nexj:model:afl-mda | ||
| nexj:model:portal | ||
nexj:model:ckeditor | ||
| nexj:model:rpc |
Schema changes for 9.4
Schema-level changes
New tables
- NJAccountPlan
- NJAccountPlanXOverview
- NJAccountPlanEntity
- NJAccountPlanOpportunity
- NJAttachmentXAccountPlan
- NJAccountPlanCov
- NJRisk
- NJCompetitor
- IFInterest
- IFVersion
Renamed tables
No tables have been renamed.
Dropped & recreated tables
No tables need to be dropped & recreated.
Removed tables
No tables were removed.
Existing tables affected by DML Upgrade SQL scripts
- NJUserField
- NJEnumDisplay
- NJEnumCode
Table-level changes:
| Modified Table | New Column | Modified Column | Renamed Column | Removed Column | New Index | Renamed Index | Dropped & Recreated Index | Removed Index |
| NJUserField | userFieldTypeId | UserField.FK_Type | ||||||
| NJAct | accountPlanId | Act.FK_AccountPlan | ||||||
| NJAct | accountPlanModified | |||||||
| NJActSeries | accountPlanId | ActSeries.FK_AccountPlan | ||||||
| NJActSeries | accountPlanModified |
Environment file changes for 9.4
- The following flags were added to the Environment file:
- rest.configMetadata
- rest.schemaBase
- rest.version
- rest.defaultPageSize
- Removed SQLHook "nexj.core.persistence.sql.ObjectQueueHook" from the Environment file and moved it to ObjectQueueDatabase.datasource
Data source connections:
| Added | Removed |
| inform:Inform RelationalDatabaseConnection |
Channel connections:
| Added | Removed |
| inform:ArticleSearch HTTPConnection | |
| rest:OpenAPI HTTPConnection | |
| rest:REST HTTPConnection | |
| rest:SelectionOptions HTTPConnection | |
| inform:RelatedObject HTTPConnection |
Mixins:
| Added | Removed | Updated minimum version |
| nexj:model:restapi | ||
| nexj:model:inform | ||
| nexj:model:afl | ||
| nexj:model:afl-mda | ||
| nexj:model:portal |
Schema changes for 9.3
Schema-level changes
New tables
- RPTOrderBy (included as of 9.2.2.0)
- RPTExecutedFiles (included as of 9.2.2.0)
- RPTEmailTarget (included as of 9.2.2.0)
Renamed tables
No tables have been renamed.
Dropped & recreated tables
No tables need to be dropped & recreated.
Removed tables
No tables were removed.
Existing tables affected by DML Upgrade SQL scripts
- NJEnumDisplay
- NJProcess
- RPTRecalculate (included as of 9.2.2.0)
Table-level changes:
| Modified Table | New Column | Modified Column | Renamed Column | Removed Column | New Index | Renamed Index | Dropped & Recreated Index | Removed Index |
| RPTCalculatedValue (modified as of 9.2.2.0) | field | |||||||
| RPTGroupBy (modified as of 9.2.2.0) | field | |||||||
| RPTDashboardItem (modified as of 9.2.2.0) | caption | |||||||
| RPTDashbaordItem (modified as of 9.2.2.0) | description | |||||||
| RPTFile (modified as of 9.2.2.0) | executedReport | File.FK_ExecReport | ||||||
| RPTFile (modified as of 9.2.2.0) | createTime | |||||||
| RPTFile (modified as of 9.2.2.0) | executedFiles | File.FK_ExeFile | ||||||
| RPTFile (modified as of 9.2.2.0) | mimeType | |||||||
| RPTFileName (modified as of 9.2.2.0) | FileName.UNIQ | |||||||
| RPTScheduledReport (modified as of 9.2.2.0) | executedTime |
Environment file changes for 9.3
- Added theme flag to Environment (to specify UI theme to load).
Channel connections:
| Added | Removed |
| ExchangeEWSSender6 HTTPConnection |
Mixins:
| Added | Removed | Updated minimum version |
| nexj:model:afl | ||
| nexj:model:afl-mda | ||
| nexj:model:portal |