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

OR statement in JQL with resolutiondate field shows incorrect results.

    XMLWordPrintable

Details

    Description

      Summary

      When using a JQL filter with the resolutiondate field and an OR statement, JIRA does not retrieve the correct results.

      Example: "resolutiondate = EMPTY OR resolutiondate >= endOfDay(-2)"

       

      Steps to Reproduce

      1. Create a sample software project in the instance
      2. Navigate to Issues > Search for issues
      3. Enter resolutiondate = EMPTY as the JQL
      4. Note the amount of results
      5. Enter resolutiondate >= endOfDay(-2) as the JQL
      6. Note the amount of results
      7. Enter resolutiondate = EMPTY OR resolutiondate >= endOfDay(-2) as the JQL

      Expected Results

      JIRA should show issues from both statements

      Actual Results

      JIRA only shows the issues from the resolutiondate >= endOfDay(-2) part of the JQL query.

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. JRACLOUD-67419 JQL equals to Empty is returning incorrect results when combining with other conditions

          • Low - Low priority issues
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. JRACLOUD-67422 latestReleasedVersion() and earliestUnreleasedVersion() functions are not working with the operators "<" and ">".

          • Medium - Medium priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. JRACLOUD-67421 Operator '=' does not show any result when used with 'createdDate'

          • Low - Low priority issues
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. JRACLOUD-67418 Equal Operator in the Issue navigator doesn't finds results for dates

          • High - High priority issues
          • Closed

          Activity

            People

              Unassigned Unassigned
              ilabras Ibrahim (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: