Uploaded image for project: 'Jira Platform Cloud'
  1. Jira Platform Cloud
  2. JRACLOUD-79304

JQL - Status Changed From and To Clauses unexpected behavior for company-managed projects

XMLWordPrintable

      Issue Summary

      JQL searches with Status Changed FROM and Status Changed TO clauses don't work for all status names for company-managed projects.

      Steps to Reproduce

      1. Create a company-managed project with some issues in different statuses
      2. Perform JQL search for example:
         project = "My project" AND status changed from 'Backlog' to 'In progress' 
      1. Perform JQL search for example:
         project = "My project" AND status changed from 'In progress' to 'Done' 

      Expected Results

      A simple JQL query should work for all status names.

      Actual Results

      JQL searches fail for Status Changed To and Status Changed From clauses for the transition from 'In progress' to 'Done'.

      Workaround

      Currently, JQL accepts the Status ID of the status you wish to search for but these are unique to the project they belong to.

      Example of a successful query:

      project = "My project" AND status changed from 4  to 10023
      

      where
              4 = 'In Progress'
      10023 = 'Done'
      To find the status ID for your project, you may use the following API call:

      GET /rest/api/3/project/<Insert project key>/statuses
      

        1. 2BD2BF7F-E7D6-40A1-80FD-59AC6DA7A7CC.png
          1.00 MB
          Hala ElRoumy
        2. 4F6FCA1D-9693-49D0-A411-16ED6C951042.png
          511 kB
          Hala ElRoumy
        3. F8D0CDE9-944B-4292-9149-06531813A899.png
          298 kB
          Hala ElRoumy
        4. image-2022-07-05-10-46-46-831.png
          891 kB
          Facundo Pedrazzini
        5. image-2022-07-05-10-47-43-114.png
          886 kB
          Facundo Pedrazzini

              Unassigned Unassigned
              e0bbe77fe18a Hala ElRoumy
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: