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)

          Form Name

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

            🦊 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. 

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

                Created:
                Updated:
                Resolved: