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

Equal Operator in the Issue navigator doesn't finds results for dates

    XMLWordPrintable

Details

    Description

      Summary

      Equal Operator ("=") in the Issue navigator doesn't finds results for dates (Updated, Resolved..)

      Environment

      Steps to Reproduce

      1. Go to the Issue Navigator
      2. Search for issues with updated date for example
      3. Check the date when a specific issue was updated
      4. Query for issues which were updated on this specific date

      Expected Results

      Issue is found

      Actual Results

      Issue is not found in the results

      Workaround

      Use a timestamp in the date value specified to ensure the full day is included. e.g.

      resolved <= "2017-08-28 23:59" instead of resolved <= "2017-08-28"

      Alternatively, you can use the endOfDay() function. The function takes an input which is a relative date specifier, so it may not be as useful.

      Attachments

        1. Equal operator.png
          98 kB
          Maja
        2. Updated equal.png
          220 kB
          Maja
        3. Updated equal 1.png
          212 kB
          Maja

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. JRACLOUD-60877 System Date Fields Are Not Working Properly in JQL

          • Low - Low priority issues
          • Closed
          has a derivative of

          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
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. JRACLOUD-25446 Search Change History - not sure of date range boundaries

          • Medium - Medium priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. JRACLOUD-29907 Operator "<=" for date don't properly query out the "=" part

          • Low - Low priority issues
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. JRACLOUD-67333 OR statement in JQL with resolutiondate field shows incorrect results.

          • Medium - Medium priority issues
          • Closed
          causes

          LYNX-1143 Loading...

          mentioned in

          Page Loading...

          Page Loading...

          Page Loading...

          Page Loading...

          Activity

            People

              3fec82897a63 Kamalesh Samal
              mgocevska Maja (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              13 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: