Breadcrumbs

Upgrade notes

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

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.
For more information, see Channel settings for a NexJ CRM deployment with Exchange Online.


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