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

XMLWordPrintable

    • 1
    • Severity 3 - Minor

      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
      

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

              Created:
              Updated:
              Resolved: