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

JQL Search Returns Issues from Other Project When Project Key and Project Name Overlap

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Low Low
    • None
    • 8.5.4, 8.13.1
    • Navigation - Search
    • None

      Issue Summary

      When trying to search a project by the project name (not project key) the results return issues from another project. This happens when you have two projects with overlapping names. The projects overlap at the Project name and Project Key. Project Key does return the results of the project but when using project name it returns results on the project key from the other project. 

      Steps to Reproduce

      1. Create a project  Project Name = ABC and Project Key = ABCD
      2. Create another project Project Name = TeamABC and Project Key = ABC
        You can see that the project key and project name "ABC" are overlapping.
      3. Make a search:
        Project = ABC
        

      Expected Results

      You would expect your see your project issues from Project ABC.

      Actual Results

      You only see issues from Project Team ABC because JQL is searching with the project key.     The results only show issues from the other project with project key ABC.

      Workaround

      The workaround is to search for issues using project key, not project name. If this is behavior is happening, it may that you have two or more projects with overlapping naming in the project key and name.
      Run the following SQL query to see if you have overlapping naming. This fix would be to change the project name of one of the projects. You can not change the project key names.

      SELECT project_key.id, project.pname, project_key.project_key
      FROM project
      LEFT JOIN project_key
      ON project.id=project_key.project_id
      ORDER BY project.pname;
      

              Unassigned Unassigned
              ea29cb78a046 Sara Hall (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated: