How can I edit the 'Has Breached' Field in list view

Russell Park
Mega Guru

I have a large list of tickets that have breached SLA and I need to remove the breach.  Instead of going into every record and changing to has breached = false I would like to be able to highlight all of them in list view and change from true to false.  I have attempted making a new ACL on the Incident_SLA table but no matter what I try I still get the "Security prevents writing to the field" message.  Any help is greatly appreciated.

I am doing this in my dev sandbox instance.find_real_file.png

find_real_file.png

3 REPLIES 3

Stephen Sturde
Tera Guru

Hi Russell - OOTB the task_sla table has list editing disabled, which you've already overcome via list control. Also OOTB, there is no restriction on editing the 'has_breached' field has no restriction on list editing. 

A couple things to check:

  • Do you have the admin or sla_admin role?
  • Has the field been set to read-only in the dictionary entry?
  • Is there another ACL already governing this field, and if so, is that ACL not overridden by admin? (see OOTB ACL screenshots below)

Please click helpful or mark correct if this worked for you.

List control setting

find_real_file.png

OOTB List edit

find_real_file.png

OOTB ACL List

find_real_file.png

OOTB Write ACL

find_real_file.png

-Stephen

Russell Park
Mega Guru
Stephen Sturdevant thanks for the response.  See my notes to each of your recommendations
  • Do you have the admin or sla_admin role?  I am logged in with the System admin and had the same results
  • Has the field been set to read-only in the dictionary entry? On the Task_sla table the dictionary entry for the "has_breached" field is not set to read only.
  • Is there another ACL already governing this field, and if so, is that ACL not overridden by admin? (see OOTB ACL screenshots below)  In your first screen shot regarding list control I did find that the "disable list editing" was selected.  Once I changed it to "Save data by rows" that allows me to edit the has breached field while on the Task_sla table.  I am still unable to edit the has breached field in list view while on the incident_sla table.  

I have tried to create and ACL for incident_sla has breached and still getting the security error while logged in as system admin.  Your help is greatly appreciated.

 

Ah. I see. You're in incident_sla, which is not a table, but rather it's a database view that combines the incident table with the task_sla table.

The easiest way for doing what you want is to go to the task_sla table, filter to your needs, and make the list edits there. 

-Stephen