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

JQL field resolved ( resolution date ) returning incorrect results

    XMLWordPrintable

Details

    Description

      Bear with me as I attempt to describe the behavior:
      1.png- An issue has been resolved less than a minute ago
      2.png- past one minute and the issue no longer shows ( correct )
      3.png- Issue is being transitioned to verify, nothing is being updated
      4.png- issue shows in filter ( incorrect )

      In the DB:

      changeitem:
       10052 |   10048 | jira      | status               | 1        | Open        | 5        | Resolved
       10053 |   10048 | jira      | resolution           |          |             | 1        | Fixed
       10054 |   10049 | jira      | status               | 5        | Resolved    | 10000    | Verified
      
      changegroup:
       10048 |   10021 | jeff   | 2010-10-04 13:30:56.808-07
       10049 |   10021 | jeff   | 2010-10-04 13:32:40.19-07
      

      Notice how the issue was resolved at 13:30:56 but the filter is returning it resolved at 13:32:40 when the issue was last updated.

      If this is desired behavior we should update the docs:
      http://confluence.atlassian.com/display/JIRA/JIRA+4.0+Upgrade+Guide#JIRA4.0UpgradeGuide-%27ResolutionDate%27SystemField

      http://confluence.atlassian.com/display/JIRA/Advanced+Searching#AdvancedSearching-Resolved

      Attachments

        1. 1.png
          1.png
          32 kB
        2. 2.png
          2.png
          12 kB
        3. 3.png
          3.png
          30 kB
        4. 4.png
          4.png
          32 kB

        Issue Links

          Activity

            People

              pleschev Peter Leschev
              jcurry Jeff Curry
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 3h
                  3h