• Type: Bug
• Resolution: Fixed
• Priority: Low
• Fix Version/s: 3.10.3, 3.10.4, 3.11.4, 3.13.0
• Affects Version/s: 3.10.2, 3.11.0, 3.11.1, 3.12.0
• Component/s: Request Type Configuration
• Labels:

  • custom-fields

1. 

   screenshot-1.png

   14 kB

   25/Apr/2018 4:09 AM

2. 

   screenshot-2.png

   55 kB

   25/Apr/2018 4:13 AM

3. 

   screenshot-3.png

   52 kB

   25/Apr/2018 4:15 AM

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

Devisree Gedda made changes - 05/Mar/2025 11:22 AM

Description

Original: h3. Summary Delete required custom field used for Customer portal will return an error when editing fields in the Request type  !screenshot-3.png|thumbnail! h3. Steps to Reproduce # Create a new custom field. # 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 be *Required*.  !screenshot-1.png|thumbnail! # Go to Custom field and delete the custom field  !screenshot-2.png|thumbnail! # Go back to Request type settings > Edit fields will return error *"Cannot Delete a field that is required by Jira or Jira Service Desk"*  !screenshot-3.png|thumbnail! h3. 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. h3. 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. !screenshot-3.png|thumbnail! h3.Workaround The current workaround is to edit the *"AO_54307E_VIEWPORTFIELD"* in the database and set the Required value to false. # Run below SQL to list out the Request types in the Service Desk {code} SELECT * from "AO_54307E_VIEWPORTFORM"; {code} (i) Take note of the ID of the affected request types # Run below SQL to list all the field in the request type affected. {code} SELECT * FROM "AO_54307E_VIEWPORTFIELD" where "FORM_ID" = <ID from Previous query>; {code} # Update the deleted customfield value and set the required value to *'f'* {code} UPDATE "AO_54307E_VIEWPORTFIELD" SET "REQUIRED" = 'f' where "FIELD_ID" = 'customfield_11301'; {code} (i) Please change the "FIELD_ID" to follow your customfield name, in this case the customfield affected is customfield_11301 # Restart JIRA.

New: h3. Summary Delete required custom field used for Customer portal will return an error when editing fields in the Request type  !screenshot-3.png|thumbnail! h3. Steps to Reproduce # Create a new custom field. # 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 be *Required*.  !screenshot-1.png|thumbnail! # Go to Custom field and delete the custom field  !screenshot-2.png|thumbnail! # Go back to Request type settings > Edit fields will return error *"Cannot Delete a field that is required by Jira or Jira Service Desk"*  !screenshot-3.png|thumbnail! h3. 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. h3. 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. !screenshot-3.png|thumbnail! h3.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. # Run below SQL to list out the Request types in the Service Desk {code} SELECT * from "AO_54307E_VIEWPORTFORM"; {code} (i) Take note of the ID of the affected request types # Run below SQL to list all the field in the request type affected. {code} SELECT * FROM "AO_54307E_VIEWPORTFIELD" where "FORM_ID" = <ID from Previous query>; {code} # Update the deleted customfield value and set the required value to *'f'* {code} UPDATE "AO_54307E_VIEWPORTFIELD" SET "REQUIRED" = 'f' where "FIELD_ID" = 'customfield_11301'; {code} (i) Please change the "FIELD_ID" to follow your customfield name, in this case the customfield affected is customfield_11301 # Restart JIRA.

Marcus Fong made changes - 07/Nov/2023 1:53 AM

Remote Link

Original: This issue links to "JSDS-2066 (JIRA Server (Bulldog))" [ 365262 ]

New: This issue links to "JSMDC-2066 (JIRA Server (Bulldog))" [ 365262 ]

Marcus Fong made changes - 07/Nov/2023 1:53 AM

Remote Link

Original: This issue links to "JSDS-1656 (JIRA Server (Bulldog))" [ 365252 ]

New: This issue links to "JSMDC-1656 (JIRA Server (Bulldog))" [ 365252 ]

Alexander (Inactive) made changes - 18/Nov/2020 2:20 AM

Link

New: This issue is related to JSDSERVER-7059 [ JSDSERVER-7059 ]

Sven Laanela (Inactive) made changes - 03/Mar/2020 3:07 AM

Fix Version/s

Original: 3.12.3 [ 80701 ]

set-jac-bot made changes - 26/Sep/2019 1:00 AM

Summary

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

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

Akmal Harith (Inactive) made changes - 29/Apr/2019 3:00 PM

Affects Version/s

New: 3.12.0 [ 78521 ]

Owen made changes - 27/Mar/2019 5:47 AM

Workflow	Original: JSD Bug Workflow v5 - TEMP [ 2662042 ]	New: JAC Bug Workflow v3 [ 3126605 ]
Status	Original: Done [ 10044 ]	New: Closed [ 6 ]

Lachlan G (Inactive) made changes - 29/Jan/2019 10:36 PM

Fix Version/s		New: 3.11.4 [ 79806 ]
Fix Version/s	Original: 3.11.3 [ 79091 ]

Ronnie Volkmar made changes - 30/Nov/2018 4:03 PM

Link

New: This issue relates to JSDSERVER-6143 [ JSDSERVER-6143 ]

Load more older history items