Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-5782

Unable to edit Request Type field configuration after previously deleting a required custom field

XMLWordPrintable

      Summary

      Delete required custom field used for Customer portal will return an error when editing fields in the Request type

      Steps to Reproduce

      1. Create a new custom field.
      2. Add the Custom field in the Request type field. (Project Settings > Request types > Edit fields > Add field > Select (Custom field).
      3. Set the custom field to be Required.
      4. Go to Custom field and delete the custom field
      5. Go back to Request type settings > Edit fields will return error "Cannot Delete a field that is required by Jira or Jira Service Desk"

      Expected Results

      Jira warns the user that the custom field is used by Customer portal and cannot be deleted. If the user deletes the custom field required by Customer portal, the field in Edit field should be shown properly without error.

      Actual Results

      No warning when user deleted required custom field used by Customer portal. If we edit the request type that associated with deleted custom field error below will appear.

      Workaround

      The current workaround is to edit the "AO_54307E_VIEWPORTFIELD" in the database and set the Required value to false.
      The provided queries are tested in PostgreSQL so please tweak the queries according to your database engine.

      1. Run below SQL to list out the Request types in the Service Desk 
        SELECT * from "AO_54307E_VIEWPORTFORM";

        Take note of the ID of the affected request types

      2. Run below SQL to list all the field in the request type affected. 
        SELECT * FROM "AO_54307E_VIEWPORTFIELD" where "FORM_ID" = <ID from Previous query>;
      3. Update the deleted customfield value and set the required value to 'f' 
        UPDATE "AO_54307E_VIEWPORTFIELD" SET "REQUIRED" = 'f' where "FIELD_ID" = 'customfield_11301';

        Please change the "FIELD_ID" to follow your customfield name, in this case the customfield affected is customfield_11301

      4. Restart JIRA.

        1. screenshot-1.png
          screenshot-1.png
          14 kB
        2. screenshot-2.png
          screenshot-2.png
          55 kB
        3. screenshot-3.png
          screenshot-3.png
          52 kB

            [JSDSERVER-5782] Unable to edit Request Type field configuration after previously deleting a required custom field

              lgoodhewcook Lachlan G (Inactive)
              abinomar Amirul Ikhwan Omar (Inactive)
              Affected customers:
              4 This affects my team
              Watchers:
              33 Start watching this issue

                Created:
                Updated:
                Resolved: