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

When using the standardIssueTypes() JQL it does not return the appropriate Issue Types

    XMLWordPrintable

Details

    Description

      Summary:

      Querying JIRA using the standardIssueTypes() JQL, expected issues are not returned.

      Environment

      • JIRA 5.2.7
      • PostgreSQL 9.1
      • Mac OS X

      Steps to Reproduce:

      1. Create a new issue using the default Issue Type "Bug" and then query for it with the following, replacing the issuekey with the appropriate key:
        issuekey = LLAMA-52 AND issuetype in standardIssueTypes()
        
      2. Add a new Issue Type "1" (without quotes).
      3. Execute the JQL again.

      Expected Results:

      The issue still appears.

      Actual Results:

      The issue vanishes.

      Notes:

      It appears that the JQL for standardIssueTypes() is querying on the quoted value instead of the actual. For example, the below will return results:

      issuekey = LLAMA-52 AND issuetype = 1
      

      This appears to go off the issuetype.id.

      However this will not:

      issuekey = LLAMA-52 AND issuetype = "1"
      

      This appears to go off issuetype.pname.

      Workaround

      Do not use Issue Types that are integers.

      Attachments

        Issue Links

          Activity

            People

              edalgliesh Eric Dalgliesh
              dcurrie@atlassian.com Dave C
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: