Uploaded image for project: 'Jira Cloud (including JIRA Core)'
  1. Jira Cloud (including JIRA Core)
  2. JRACLOUD-70797

JQL query search using "status" returns incorrect unreliable results

    XMLWordPrintable

    Details

      Description

      Summary

      When searching for issues using a "status" statements ("status was", "status =", "status changed"), the results are unreliable. This happens if there is a Next-gen project in the Jira's Cloud instance.

      Steps to Reproduce

      1. Search for issues using a "status was in/was not in (status1, status2) on date" argument;

      Expected Results

      • All the issues that were on that statuses on that date returns as result of the query.

      Actual Results

      • Some issues show in the result of the query. Other that also matches the argument, don't.

      Update on April the 17th, 2020!

      This problem is very consistent on issues that are imported through a .CSV file and are on a different status than the query.

      Workaround(s)

      • Jira admins can leverage the REST API GET /rest/api/2/status against their Cloud instances to retrieve the ID of the statuses and then use it in JQL queries;
        • Update on April the 17th, 2020! The workaround above seems to not be working.
      • To retrieve the ID of statuses used by Classic projects, Jira admins can also type the g key twice on their keyboard (gg) or, as alternative, their period key ( . ), then Statuses, hover the mouse over the "Edit" option on the relevant status and write down the number shown in the end of the URL.

        Attachments

        1. JRACLOUD-70797-1.png
          JRACLOUD-70797-1.png
          100 kB
        2. JRACLOUD-70797-2.png
          JRACLOUD-70797-2.png
          151 kB
        3. JRACLOUD-70797-3.png
          JRACLOUD-70797-3.png
          117 kB
        4. JRACLOUD-70797-4.png
          JRACLOUD-70797-4.png
          424 kB

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              rgebhardt@atlassian.com Ricardo Gebhardt (Inactive)
              Votes:
              9 Vote for this issue
              Watchers:
              19 Start watching this issue

                Dates

                Created:
                Updated: