Historical JQL searches return wrong results after applying workaround(JRACLOUD-84058)

XMLWordPrintable

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Low
    • None
    • Affects Version/s: 10.0.0
    • Component/s: JQL
    • None
    • 10
    • 2
    • Severity 3 - Minor

      Issue Summary

      Customers might experience trouble running historical JQL searches using WAS/WAS IN with BEFORE/AFTER/DURING/ON.

      Steps to Reproduce

      Run one of the following example JQLs:
      status WAS closed DURING ('2024-01-01', '2024-01-31')
      assignee WAS currentUser() AFTER/BEFORE startOfYear(-1)
      priority WAS P1 ON '2024-01-01'

      Expected Results

      Issues within the date range and condition are returned.

      Actual Results

      In some cases, the historical JQL search will return additional issues or no issues. Issues that had value X set to <field> before A but it has been later (before A) changed.
      This is caused by corrupted data in the history of some issues. Only JQL is affected, as that data is only used by the search engine.

      Workaround

      The workaround shared under ticket: https://jira.atlassian.com/browse/JRACLOUD-84058 is not working

            Assignee:
            Unassigned
            Reporter:
            Gabriel Aguilera
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: