Uploaded image for project: 'Jira Align'
  1. Jira Align
  2. JIRAALIGN-6160

Jira Integration - Adding Projects to the query appends a leading comma to the "JQL Query Preview" field

XMLWordPrintable

    • 3
    • Severity 2 - Major
    • No

      Issue Summary

      The JQL instruction in Jira Integration is adding commas ( , ) in the JQL, causing users to be confused.

      This happens when the value of "Jira Project Key" and "Jira Project Name" is empty in the Jira Projects managed.

       

      Steps to Reproduce

      1. There are two scenarios in which we can trigger this issue in the Jira Integration and Jira Settings:
        1. Set the "Project Keys" value empty in the Jira Align database.
        2. Updating the Project Key and Project Name as empty.

      This can be checked using the method GET in the following API endpoint -> /rest/align/api/2/Connectors/1/Projects?$filter=projectKey eq null


       

      Expected Results

       

      The JQL generated in the "Jira Integration" tab doesn't add any commas to incorrect Jira Projects created in the Jira Align.

      Actual Results

       

      The JQL generated in the "Jira Integration" tab is incremented correctly with valid Jira Projects.

      Workaround

      1. Browse to the Jira Settings page, then select the appropriate connector ID in the Connector dropdown
      2. Select the Manage Projects tab
      3. Look for any Jira Project saved with incomplete data, as demonstrated in the example below:
      4. For each one that's been found, insert a Project Key and Project Name; then save it
      5. To open that entry, click on it Project Key; then delete it:
      6. Select the Jira Integration tab
      7. In the Projects field, select a project; then check the JQL Query Preview field:

        1. image-2023-11-16-15-20-16-106.png
          85 kB
          Luiz Felipe Arruda
        2. image-2023-11-16-15-43-20-560.png
          119 kB
          Luiz Felipe Arruda
        3. image-2023-11-16-15-44-05-481.png
          119 kB
          Luiz Felipe Arruda
        4. image-2023-11-16-15-50-06-465.png
          91 kB
          Luiz Felipe Arruda
        5. image-2023-11-16-15-50-50-965.png
          91 kB
          Luiz Felipe Arruda
        6. image-2023-11-16-15-52-35-807.png
          12 kB
          Luiz Felipe Arruda
        7. image-2023-11-16-15-53-07-842.png
          23 kB
          Luiz Felipe Arruda
        8. image-2023-11-16-15-54-08-772.png
          87 kB
          Luiz Felipe Arruda

              fea1a6ef3355 Yannick Genin
              f9fc804f30c6 Luiz Felipe Arruda
              Votes:
              7 Vote for this issue
              Watchers:
              12 Start watching this issue

                Created:
                Updated:
                Resolved: