Details
-
Bug
-
Resolution: Fixed
-
Highest
-
3.13.0, 3.13.1, 3.13.2, 3.14.0, 3.14.2, 3.15.0, 3.15.3, 3.16.0, 3.16.1, 4.0.0, 4.0.2, 4.1.0
-
12
-
Severity 2 - Major
-
108
-
Description
Summary
when changing the required option for a custom field used for a request form, AO_54307E_VIEWPORTFIELD isn't being updated (the cache doesn't appear to be cleared either, therefor you get this error:
This is similar to JSDSERVER-5782 but different as you're not deleting the custom field just changing the required option:
Steps to reproduce
- Create a new custom field.
- Set the custom field to be Required.
- Add the custom field to a service desk screen
- Add the Custom field in the Request type field. (Project Settings > Request types > Edit fields > Add field > Select (Custom field).
- Set the custom field to Optional
- remove the custom field from the service desk screen
- try to edit the request type fields
Expected Behavior
Service Desk will now allow you to remove the field
Actual Behavior
Service Desk throws an error "Cannot delete a field that is required by Jira or Jira Service Desk."
Cause
When the custom field is set to optional the REQUIRED field in AO_54307E_VIEWPORTFIELD table isn't being updated for the request type:
Workaround:
- 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
- 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>;
- Update the deleted custom field value and set the required value to 'f'
UPDATE "AO_54307E_VIEWPORTFIELD" SET "REQUIRED" = 'f' where "ID" =<ID for relevant custom field>';
- Either restart JIRA OR to clear the Request form cache simply navigate to another Service Desk project and edit and save a Request Type that is NOT using the same screen as the affected project, this should flush the Request form cache.
Attachments
Issue Links
- is related to
-
JSDSERVER-5782 Unable to edit Request Type field configuration after previously deleting a required custom field
- Closed
- relates to
-
JSDSERVER-5981 Alert admin when request type is configured with invalid default value
- Gathering Interest
-
PSR-227 Loading...
- was cloned as
-
JSDS-3490 Loading...