Uploaded image for project: 'Jira Software Data Center'
  1. Jira Software Data Center
  2. JSWSERVER-7826

The JQL builder puts the ID of Status and Issue Types as a string and this can cause no issues to be returned

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Low
    • None
    • 6.1.3.2
    • None

    Description

      Summary

      When attempting to render a board, if the JIRA instance has Issue Types or Statuses that are integers, it will prevent certain issues from being displayed on the board. They are still displayed in the Issue Navigator, however.

      Steps to Reproduce

      1. Create an issue with a Status of "Open".
      2. Save a filter for that issue.
      3. Create a new board with that filter.
      4. Verify the issue appears.
      5. Add a status of "1".
      6. Check the board - the issue will vanished.

      Expected Results

      The issue does not disappear.

      Actual Results

      The issue does not appear on the board.

      Notes

      This appears to be caused by the JQL builder putting the id of the status (and also issue type) within a string. For example:

      $ 2013-03-01 12:16:22,027 http-bio-8900-exec-4 DEBUG wonderwoman 736x4724x2 7hi14c 172.22.2.187 /rest/greenhopper/1.0/xboard/work/allData.json [issue.search.providers.LuceneSearchProvider] JQL query: {issuekey = "sfti-825"} AND ( {fixVersion in unreleasedVersions()} OR {fixVersion is EMPTY} ) AND {status in ("3", "10002", "1", "10005", "4", "10009")}
      

      It should be querying them directly as a the literal integer, ie 1 vs "1".

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              dcurrie@atlassian.com Dave C
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: