Jira Align EI Enhancements and Features Version 10.111.X

Jira Align's Enterprise Insights (EI) was updated and deployed to 10.111.X instances on the continuous track on September 17, 2022, and will be deployed to instances on the bundled track on September 23, 2022. The following enhancements were made:

Release highlights

  • New content:

    • JIRAALIGN-4022 - Added Skill request estimate (allocation) for Epic/Feature work items.

    • JIRAALIGN-4142 - Added Jira Connector Logs.
    • JIRAALIGN-4227 - Added [Audit Log Detail] object for Program Increment changes on work items.
    • Added Creator Full Name and Flag values to ideas.

    • Feature Skill object added.

  • Defect fixes: 

    • JIRAALIGN-4309 - Corrected Owner Full Name mapping.

    • JIRAALIGN-4310 - Corrected Owner Flag & FK User Owner ID field mapping for external owners.

    • Corrected FK Split Epic/Capability ID.

    • Corrected Deletion Flag logic for MAP Goal to Snapshot.

New tables

View Name

Description

Audit Log Detail

Added Audit Log Detail - to capture program increment changes for work items.

  • [Audit Log Detail ID] INT NOT NULL PRIMARY KEY
  • [Date Updated] DATETIME NULL
  • [Details] NVARCHAR(MAX) NULL
  • [FK Agile Object ID] INT NOT NULL
  • [FK Audit Log ID] INT NOT NULL
  • [FK Object Item ID] INT NOT NULL
  • [FK Program Increment ID] INT NOT NULL
  • [FK User Updated By ID] INT NOT NULL

Epic Skill Allocation

Skill request estimates (allocation) for Epic object.

  • [Epic Skill Allocation ID] INT NOT NULL PRIMARY KEY
  • [FK Anchor Sprint ID] INT NOT NULL
  • [FK Epic ID] INT NOT NULL
  • [FK Skill ID] INT NOT NULL
  • [Member Week Value] FLOAT NULL

Feature Skill

Skills requested for Feature object.

  • [Feature Skill ID] INT NOT NULL PRIMARY KEY
  • [FK Feature ID] INT NOT NULL
  • [FK Skill ID] INT NOT NULL
  • [Skill Group] NVARCHAR(500) NULL
  • [Skill Name] NVARCHAR(500) NULL

Feature Skill Allocation

Skill request estimates (allocation) for Feature object.

  • [Feature Skill Allocation ID] INT NOT NULL PRIMARY KEY
  • [FK Anchor Sprint ID] INT NOT NULL
  • [FK Feature ID] INT NOT NULL
  • [FK Skill ID] INT NOT NULL
  • [Member Week Value] FLOAT NULL

Jira Connector Log

Added Jira Connector Log.

  • [Date Audit Event] DATETIME NULL
  • [Details] NVARCHAR(MAX) NULL
  • [FK Agile Object ID] INT NOT NULL
  • [FK Jira Board ID] INT NOT NULL
  • [FK Connector ID] INT NOT NULL
  • [FK Jira Fix Version ID] INT NOT NULL
  • [FK Jira Sprint ID] INT NOT NULL
  • [FK Object Item ID] INT NOT NULL
  • [Jira Connector Log ID] INT NOT NULL PRIMARY KEY
  • [Jira Object Name] NVARCHAR(50) NULL
  • [Jira Object Type] NVARCHAR(50) NULL
  • [Message Type] NVARCHAR(50) NULL


Updated tables

View Name

Description

External Reference

Added External Reference links for goals, release vehicles & themes.

  • [FK Goal ID] INT NOT NULL
  • [FK Release Vehicle ID] INT NOT NULL
  • [FK Theme ID] INT NOT NULL

Idea

Added columns to fully distinguish external creator & owner foreign keys and flags.

  • [Creator Full Name] NVARCHAR(404) NULL
  • [External Owner Flag] VARCHAR(3) NULL
  • [FK User Created By ID] INT NOT NULL
  • [FK User External Created By ID] INT NOT NULL
  • [FK User Owner ID] INT NOT NULL

Objective History

Added Health column to objective history.

  • [Objective Health] NVARCHAR(50) NULL

 

Was this article helpful?
0 out of 0 found this helpful
Print Friendly Version of this pagePrint Get a PDF version of this webpagePDF

Join the Atlassian Community!

The Atlassian Community is a unique, highly collaborative space where customers and Atlassians come together. Ask questions and get answers, start discussions, and collaborate with thousands of other Jira Align customers. Visit the Jira Align Community Collection today.

Need to contact Jira Align Support? Please open a support request.