Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-65285

NOT function in JQL is not working as expected in JIRA version 7.2 and Above

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Low
    • None
    • 7.2.1, 7.3.6
    • JQL
    • None

    Description

      Summary

      JQL function for NOT seems to be depreceated starting from JIRA version 7.2, the same JQL function works fine in JIRA version prior to 7.1

      Environment

      • JIRA version 7.2.x
      • JIRA version 7.3.x

      Steps to Reproduce

      1. Go to issue navigator and run this JQL query
        project = TEST AND NOT (status was in (Done)) ORDER BY Rank ASC
        

      Expected Results

      The JQL returns the result as there is no error shown for the JQL configuration.

      Actual Results

      Running above JQL throws below error message

      Notes

      This JQL feature works fine in JIRA version prior to 7.2, below is the result as tested with version 7.1

      Workaround

      Currently in JIRA version 7.2 and 7.3 customer can use below JQL to get similar result

      project = TEST AND status was not Done ORDER BY Rank ASC
      

      Attachments

        1. result in 71x.PNG
          result in 71x.PNG
          40 kB
        2. result in 73x.PNG
          result in 73x.PNG
          26 kB

        Issue Links

          Activity

            People

              Unassigned Unassigned
              smanimaran Shan Sharma Manimaran (Inactive)
              Votes:
              2 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated: