SLA is not displayed for existing issues if JQL using Customer Request Type

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Low
    • 4.18.1
    • Affects Version/s: 4.9.0, 4.17.0
    • Component/s: SLA
    • 1
    • Severity 3 - Minor

      Issue Summary

      SLA is not displayed for existing issues if JQL using Customer Request Type

      Steps to Reproduce

      1. Create support request with Get IT help customer request type
      2. Create SLA condition

      Expected Results

      SLA displayed properly

      Actual Results

      SLA is empty. If the customer creates a new ticket, SLA is shown properly.

      Reconstruct API is not solving the issue.

      Workaround

      Customer Request Type values follow the format of "key/lowercased-form-title-hyphenated". Use this format in JQL instead.
      For example project key of "IT":

      JQL example
      "Customer Request Type" = "it/getithelp"

      Get the full list of request types + string value for each project:

      postgres
      SELECT p.pname, r."NAME" as request_type_name , (po."KEY" || '/' || r."KEY") AS request_type_key 
      FROM "AO_54307E_VIEWPORT" po, "AO_54307E_VIEWPORTFORM" r, project p 
      WHERE po."ID"=r."VIEWPORT_ID" AND po."PROJECT_ID"=p.id
      ORDER BY p.pname

        1. image-2021-05-19-14-00-20-298.png
          388 kB
          Tomoko Suzuki
        2. Screen Shot 2021-05-19 at 13.58.14.png
          197 kB
          Tomoko Suzuki

            Assignee:
            Unassigned
            Reporter:
            Tomoko Suzuki
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: