Uploaded image for project: 'Jira Software Data Center'
  1. Jira Software Data Center
  2. JSWSERVER-20101

When Using Greater Than Or Smaller Than (comparison operator) In JQL Search, It Return Results Like >= or <=

XMLWordPrintable

      Issue Summary

      When Using Greater Than Or Smaller Than (comparison operator) In JQL Search, It Return Results Like >= or <=

      Environment

      JIRA 8.2

      Steps to Reproduce

      Run below JQL Query:-

      project in ("JIRA") AND  (fixVersion > 8.0.0 and fixVersion <= 8.1.0)

      Expected Results

      Return issue with fixed version after 8.0.0 to 8.1.0. JIRA fixed in 8.0.0 shouldn't show.
      Assuming the fixed version was with only 1 fixed version.

      Actual Results

      Results returned JIRA 8.0.0 as well

      Workaround

      Write JQL with 1 version after the version you doesn't wish to show such as:-

      project in ("JIRA") AND  (fixVersion > 8.0.1 and fixVersion <= 8.1.0)

            [JSWSERVER-20101] When Using Greater Than Or Smaller Than (comparison operator) In JQL Search, It Return Results Like >= or <=

            🦊 Fox (Inactive) made changes -
            Resolution New: Not a bug [ 12 ]
            Status Original: Needs Triage [ 10030 ] New: Closed [ 6 ]

            🦊 Fox (Inactive) added a comment -

            Hi!

            Thank you very much for submitting this issue. 

            Upon further investigation we were unable to reproduce this bug on 7.13, 8.0, 8.2 and 8.3 and came to a conclusion that the JQL works as intended.

            In each of our testing cases whenever a fixVersion = 8.0.0 was set and query for fixVersion > 8.0.0 was performed, the issue was not returned.

            Mind you, it is possible to set multiple fix versions on a single issue. 

            Therefore if you set fixVersion = 8.0.0, 8.0.1 and make a query for fixVersion > 8.0.0 the issue will still be returned as the second set fixVersion matches the intended query.

            This is an intended behaviour. 

            🦊 Fox (Inactive) added a comment - Hi! Thank you very much for submitting this issue.  Upon further investigation we were  unable to reproduce  this bug on 7.13, 8.0, 8.2 and 8.3 and came to a conclusion that the JQL works as intended. In each of our testing cases whenever a  fixVersion = 8.0.0  was set and query for  fixVersion > 8.0.0 was performed , the issue was not returned. Mind you, it is possible to set multiple fix versions on a single issue.  Therefore if you set  fixVersion = 8.0.0, 8.0.1  and make a query for  fixVersion > 8.0.0  the issue will still be returned as the second set fixVersion matches the intended query. This is an intended behaviour. 
            Kamil Cichy (Inactive) made changes -
            Comment [ A comment with security level 'atlassian-staff' was removed. ]
            Mateusz Marzęcki made changes -
            Labels New: delta warranty
            Bugfix Automation Bot made changes -
            Support reference count New: 1
            Bugfix Automation Bot made changes -
            Introduced in Version New: 8.02
            Danson (Inactive) created issue -

              Unassigned Unassigned
              dkoh Danson (Inactive)
              Affected customers:
              1 This affects my team
              Watchers:
              6 Start watching this issue

                Created:
                Updated:
                Resolved: