Uploaded image for project: 'Jira Software Data Center'
  1. Jira Software Data Center
  2. JSWSERVER-6651

Agile boards have Days in Column value offset by a large incorrect amount

      Summary

      Agile boards have Days in Column value offset by a large incorrect amount

      Steps to Reproduce

      1. Create or use a project with an agile simplified workflow.
      2. Ensure the Days in Column feature is enabled.
      3. On the board, transition an issue to the same status it is currently in.
      4. View Days in Column

      Expected Results

      The Days in Column value remains the same.

      Actual Results

      The Days in Column dots max out and mousing over displays a huge value (e.g. over 16k days).

      Solution / Workaround

      Transition the ticket to other status, and then back to the target column. Consider changing the workflow to prevent recursive transitions.

      Notes/Details

      ".. days in column" data is based on opt_data.issue.timeInColumn.days value and is calculated the following way:

      if (b.timeInColumn) {
      b.timeInColumn.days = Math.floor((b.timeInColumn.durationPreviously + new Date().getTime() - b.timeInColumn.enteredStatus) / a)
      }
      

      which is calculated from timeInColumn value from JSON https://<JIRA>/rest/greenhopper/1.0/xboard/work/allData.json?rapidViewId=<BOARD_ID>.
      Normally, this data looks like:

      "timeInColumn": {
        "enteredStatus": 1442936354000,
        "durationPreviously": 0
      },
      

      in case of an issue was transitioned to the same status it is currently in:

      "timeInColumn": {
        "enteredStatus": 0,
        "durationPreviously": 2301491000
      },
      

      which leads to large opt_data.issue.timeInColumn.days value

            [JSWSERVER-6651] Agile boards have Days in Column value offset by a large incorrect amount

            Bugfix Automation Bot made changes -
            Minimum Version New: 6
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2853290 ] New: JAC Bug Workflow v3 [ 2937306 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v7 - Restricted [ 2545738 ] New: JAC Bug Workflow v2 [ 2853290 ]
            Ignat (Inactive) made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 - Restricted [ 1552122 ] New: JIRA Bug Workflow w Kanban v7 - Restricted [ 2545738 ]
            Confluence Escalation Bot (Inactive) made changes -
            Labels Original: fixme papercuts pse-request short-term ui New: affects-server fixme papercuts pse-request short-term ui
            Owen made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 [ 908636 ] New: JIRA Bug Workflow w Kanban v6 - Restricted [ 1552122 ]
            Martin (Inactive) made changes -
            Fix Version/s New: Available in JIRA Software Cloud [ 62092 ]
            bmccoy made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: Soaking [ 10041 ] New: Resolved [ 5 ]
            bmccoy made changes -
            Assignee New: bmccoy [ bmccoy ]
            Status Original: Awaiting Soak [ 10040 ] New: Soaking [ 10041 ]
            bmccoy made changes -
            Fix Version/s New: 2016-01-25 Cloud [ 60461 ]
            Fix Version/s Original: Next Cloud Release [ 60093 ]

              bmccoy bmccoy
              igrunert ig (Inactive)
              Affected customers:
              35 This affects my team
              Watchers:
              39 Start watching this issue

                Created:
                Updated:
                Resolved: