-
Type:
Suggestion
-
Resolution: Unresolved
-
Component/s: Epics - Attribute
-
7
Issue Summary
The Process Step Assignment History is sourced from the Jira Align table tblAgileWIPValueHistory, which does not include the same data as the Feature/Story/Epic Log which is sourced from the Jira Align table tblAuditLog.
The primary concern is the discrepancy between actual updates made to workitem' process steps in the UI and how these updates are recorded (or not recorded) in the database. Despite successful logging of these changes in both the Feature/Story/Epic Log Table and Audit Log, the Feature Process Step Assignment History fails to reflect these updates. This inconsistency poses a risk of presenting incorrect data in Enterprise Insights regarding the current process steps of features, especially when these features are associated with multiple value streams.
Steps to Reproduce
- Within a value stream, change the process step for a feature or a epic.
- Verify that the change is reflected in both the Feature Log Table and Audit Log.
- Inspect the Feature Process Step Assignment History for the recorded change.
- Move feature back to a previous process step in the process flow.
- Verify that the change is reflected in both the Feature Log Table and Audit Log.
- Inspect the Feature Process Step Assignment History for the recorded change. Notice records for the previous process step history are missing.
Expected Results
Every change made to a workitem process step within a value stream should be consistently logged across the work item Log Table, Audit Log, and especially within the Work teim Process Step Assignment History, ensuring that Enterprise Insights can load all the Process Steps History from tblAgileWIPValueHistory
Actual Results
The following query returned these results which does not match the Log results, showing the mismatch is in Jira Align.
SELECT history.AuditID AS [Process Step Assignment History ID], CASE WHEN history.ObjectType = 1 THEN 2 --Epic WHEN history.ObjectType = 2 THEN 3 --Feature WHEN history.ObjectType = 3 THEN 4 --Story WHEN history.ObjectType = 4 THEN 1 --Theme WHEN history.ObjectType = 5 THEN 43 --Capability END AS [Agile Object ID], N'No' AS [Deleted Flag], --Dates history.StartDate AS [Assignment Start Date], history.EndDate AS [Assignment End Date], --Foreign Keys ISNULL(history.ObjectID, 0) AS [FK Object Item ID], ISNULL(history.LifeCycleStateID, history.LifeCycleStateOp) AS [FK Process Step ID], ISNULL(Lkp_AssignedBy.Uniq, 0) AS [FK User Assigned By ID], ISNULL(history.LifeCycleProgramSetID, 0) AS [FK Value Stream ID] FROM tblAgileWIPValueHistory history LEFT OUTER JOIN sysmemberpermssion Lkp_AssignedBy ON Lkp_AssignedBy.UID = history.MovedBy WHERE ISNULL(history.ObjectID, 0) = 13018
Process Step Assignment History ID : 6478 Agile Object ID : 3 Deleted Flag : No Assignment Start Date : 11/10/2022 7:57:11 PM Assignment End Date : 11/10/2022 8:13:06 PM FK Object Item ID : 13018 FK Process Step ID : 890 FK User Assigned By ID : 661822 FK Value Stream ID : 241 Process Step Assignment History ID : 6479 Agile Object ID : 3 Deleted Flag : No Assignment Start Date : 11/10/2022 8:13:06 PM Assignment End Date : 11/16/2022 4:31:46 AM FK Object Item ID : 13018 FK Process Step ID : 893 FK User Assigned By ID : 661690 FK Value Stream ID : 242 Process Step Assignment History ID : 6480 Agile Object ID : 3 Deleted Flag : No Assignment Start Date : 11/10/2022 8:13:06 PM Assignment End Date : 11/10/2022 8:13:06 PM FK Object Item ID : 13018 FK Process Step ID : 891 FK User Assigned By ID : 661690 FK Value Stream ID : 241 Process Step Assignment History ID : 6481 Agile Object ID : 3 Deleted Flag : No Assignment Start Date : 11/10/2022 8:13:06 PM Assignment End Date : FK Object Item ID : 13018 FK Process Step ID : 892 FK User Assigned By ID : 661690 FK Value Stream ID : 241 Process Step Assignment History ID : 6570 Agile Object ID : 3 Deleted Flag : No Assignment Start Date : 11/16/2022 4:31:46 AM Assignment End Date : FK Object Item ID : 13018 FK Process Step ID : 894 FK User Assigned By ID : 661692 FK Value Stream ID : 242 Process Step Assignment History ID : 12557 Agile Object ID : 3 Deleted Flag : No Assignment Start Date : 2/21/2024 9:04:20 PM Assignment End Date : 2/21/2024 9:15:34 PM FK Object Item ID : 13018 FK Process Step ID : 1207 FK User Assigned By ID : 661690 FK Value Stream ID : 327 Process Step Assignment History ID : 12560 Agile Object ID : 3 Deleted Flag : No Assignment Start Date : 2/21/2024 9:15:34 PM Assignment End Date : 2/21/2024 9:15:34 PM FK Object Item ID : 13018 FK Process Step ID : 1208 FK User Assigned By ID : 661690 FK Value Stream ID : 327 Process Step Assignment History ID : 12561 Agile Object ID : 3 Deleted Flag : No Assignment Start Date : 2/21/2024 9:15:34 PM Assignment End Date : FK Object Item ID : 13018 FK Process Step ID : 1209 FK User Assigned By ID : 661690 FK Value Stream ID : 327
Workaround
Currently there is no known workaround for this behavior. A workaround will be added here when available
- causes
-
ALIGNSP-30995 Loading...
- is connected to
-
- is related to
-
- relates to
-
- resolves
-