How can I edit the 'Has Breached' Field in list view
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-25-2018 08:38 AM
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.
- Labels:
-
Incident Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-25-2018 01:37 PM
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
OOTB List edit
OOTB ACL List
OOTB Write ACL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-25-2018 05:37 PM
- 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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-25-2018 06:40 PM
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.