IMPORTANT: JAC is a Public system and anyone on the internet will be able to view the data in the created JAC tickets. Please don’t include Customer or Sensitive data in the JAC ticket.
Uploaded image for project: 'Advanced Roadmaps'
  1. Advanced Roadmaps
  2. JPOSERVER-2727

JQL searches using "Target end" or "Target Start" dates return 0 or incorrect results

This issue belongs to an archived project. You can view it, but you can't modify it. Learn more

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Highest Highest
    • 3.21.0
    • 3.18.0, 3.18.1, 3.19.0, 3.19.1, 3.20.0
    • Usability
    • None

      Issue Summary

      Performing a JQL search using "Target end" or "Target start" dates returns 0 or incorrect results. For example:  'project = "Project name" AND "Target end" is EMPTY' returns data with Target end having actual date not EMPTY. The same for NULL.

      Another example JQL that will break: 'project = ABCD AND "Target End" >= '2020-01-01' AND "Target End" < '2020-03-01''

      Steps to Reproduce

      1. Create a project and some issues
      2. Create a Jira Portfolio plan using the new project
      3. Update some issues in the plan with a "Target end" or "Target start" date
      4. Perform the JQL search 'project = "Project name " AND "Target end" is EMPTY' or 'project = Blah AND "Target start" >= '2020-01-01''
      5. Note the results return as expected. 
      6. Complete a Full reindex. 
      7. Repeat the same JQL searches. 

      Expected Results

      Return only issues with Target end where it's empty or returns the issues that meet that the JQL parameters. Note: Before the reindex, expected results are found. After the reindex they are not. 

      Actual Results

      It returns all data for both empty Target end date and non-empty.

      Workaround

      A background index will temporary remediate the issue. No permanent solution has been found. 

            Loading...
            IMPORTANT: JAC is a Public system and anyone on the internet will be able to view the data in the created JAC tickets. Please don’t include Customer or Sensitive data in the JAC ticket.
            Uploaded image for project: 'Advanced Roadmaps'
            1. Advanced Roadmaps
            2. JPOSERVER-2727

            JQL searches using "Target end" or "Target Start" dates return 0 or incorrect results

            This issue belongs to an archived project. You can view it, but you can't modify it. Learn more

              • Icon: Bug Bug
              • Resolution: Fixed
              • Icon: Highest Highest
              • 3.21.0
              • 3.18.0, 3.18.1, 3.19.0, 3.19.1, 3.20.0
              • Usability
              • None

                Issue Summary

                Performing a JQL search using "Target end" or "Target start" dates returns 0 or incorrect results. For example:  'project = "Project name" AND "Target end" is EMPTY' returns data with Target end having actual date not EMPTY. The same for NULL.

                Another example JQL that will break: 'project = ABCD AND "Target End" >= '2020-01-01' AND "Target End" < '2020-03-01''

                Steps to Reproduce

                1. Create a project and some issues
                2. Create a Jira Portfolio plan using the new project
                3. Update some issues in the plan with a "Target end" or "Target start" date
                4. Perform the JQL search 'project = "Project name " AND "Target end" is EMPTY' or 'project = Blah AND "Target start" >= '2020-01-01''
                5. Note the results return as expected. 
                6. Complete a Full reindex. 
                7. Repeat the same JQL searches. 

                Expected Results

                Return only issues with Target end where it's empty or returns the issues that meet that the JQL parameters. Note: Before the reindex, expected results are found. After the reindex they are not. 

                Actual Results

                It returns all data for both empty Target end date and non-empty.

                Workaround

                A background index will temporary remediate the issue. No permanent solution has been found. 

                        dshaw2@atlassian.com David Shaw
                        estorch Eric Storch (Inactive)
                        Archiver:
                        atibrewal@atlassian.com Aakrity Tibrewal

                          Created:
                          Updated:
                          Resolved:
                          Archived:

                            dshaw2@atlassian.com David Shaw
                            estorch Eric Storch (Inactive)
                            Archiver:
                            atibrewal@atlassian.com Aakrity Tibrewal

                              Created:
                              Updated:
                              Resolved:
                              Archived: