Uploaded image for project: 'Jira Software Cloud'
  1. Jira Software Cloud
  2. JSWCLOUD-24004

Can't put multiple sprint IDs in sprint field when bulk changing issues

    XMLWordPrintable

Details

    • 0
    • 1
    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

    Description

      Issue Summary

      It is not possible to input multiple sprint IDs in the sprint field when bulk changing/moving issues. It only accepts single sprint ID.

      Background:
      Editing the sprints field value is only possible by performing the bulk operation. (reference: JSWCLOUD-10548: Cloned issues inherit the Completed Sprint value and can't be removed). However, when we perform bulk change, it will not allow us to input multiple sprint IDs. This will cause a loss of sprint field values.

      Steps to Reproduce

      1. search for the affected issues in the Issue Navigator and enter criteria that returns the issue or issues for which you want to remove the Sprint information.
      2. click ... > Bulk Change issues;
      3. Choose issues and click Next:
      4. select Edit Issues and click Next;
      5. select Change Sprint and add multiple sprint IDs.
      6. click Next and it will throw this error: "Sprint id must be a number"

      Expected Results

      User should be able to add multiple sprint IDs and then hit submit.

      Actual Results

      Only single ID is available.

      Workaround

      It is possible to update the Sprint fields via CSV import.

      Before making any changes:

      • Create a Backup of the Jira cloud instance
      • Export project data to CSV to have individual project’s backup in case any data mining is required in future.

      Workaround Steps

      Video Tutorial: CSV Import.mp4

      1. Find the Sprint IDs via the Sprint Report URL:

           For example, in this URL Sprint ID is 134.

      https://fabzytest.atlassian.net/jira/software/c/projects/MSTUSVC/boards/97/reports/sprint-retrospective?sprint=134 

                   Last Completed Sprint 4 ID = 133
                    Active Sprint 5 ID = 134
      2. From Filters → Advanced issue search write a JQL to retrieve the issues that must be updated.

      Sprint Data before modification:
       

      project = "My scrum to update sprints via csv" and sprint in (130,131,132,133,134) 

       
               2.1 Select Key, Summary, and Sprint columns.

               2.2 Select Export → Export Excel CSV ( my defaults).

      3. Edit the CSV file and remove the extra Sprint columns.
      4. Update the CSV file with the desired Sprint ID.
      5. Jira-Administrator go to Settings-> System → External System Import → CSV.
      6. All the columns must be mapped during the import.
      7. Beign Import

      Sprint Data after CSV import:
       

      project = "My scrum to update sprints via csv" and Sprint is not EMPTY 

      Attachments

        1. CSV Import.mp4
          8.08 MB
        2. image-2023-01-31-17-49-58-368.png
          image-2023-01-31-17-49-58-368.png
          266 kB
        3. image-2023-01-31-17-50-22-770.png
          image-2023-01-31-17-50-22-770.png
          95 kB
        4. image-2023-01-31-17-50-39-284.png
          image-2023-01-31-17-50-39-284.png
          156 kB
        5. image-2023-01-31-17-50-57-205.png
          image-2023-01-31-17-50-57-205.png
          213 kB
        6. image-2023-01-31-17-51-20-228.png
          image-2023-01-31-17-51-20-228.png
          266 kB
        7. image-2023-02-01-17-37-57-074.png
          image-2023-02-01-17-37-57-074.png
          141 kB
        8. screenshot-1.png
          screenshot-1.png
          49 kB
        9. screenshot-2.png
          screenshot-2.png
          141 kB
        10. screenshot-3.png
          screenshot-3.png
          92 kB

        Activity

          People

            Unassigned Unassigned
            f098360725e2 iDa Khoshvaght
            Votes:
            2 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated: