Upgrade notes
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.tokenURL
property 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 |