Why bulk update using Update Selected/Update All not working for certain table?

Khang1 · ‎01-11-2020

The specific table I'm working on is 'sn_compliance_control'. From the list view, I select some records, click on the list context menu and choose 'Update Selected'. The editing form popped up but all the fields are read-only and don't let me do bulk update. I check the bulk update with some other tables and it works fine.

Can anyone help pointing out what restriction in place on the table that doesn't allow bulk update? Greatly appreciate it.

The SN Nerd · ‎01-12-2020

This is just a reflection of how the ACL's evaluate against a Control record that is empty.

You can work around this by following the steps below:

Create a write ACL on the Control table for the 'list_updater' role.

Add the following script to ensure it only functions for list update screen:

// Makes fields editable on update all screen
answer = gs.nil(current.getValue('sys_id') );

You may need to create a wildcard rule as well if the above does not work.

ServiceNow Nerd
ServiceNow Developer MVP 2020-2022
ServiceNow Community MVP 2019-2022

View solution in original post

Chuck Tomasi · ‎01-11-2020

Have you checked ACLs? It could be a security issue. Can you edit those fields on a single record if you open it up from the list?

Khang1 · ‎01-11-2020

Yes, I have admin access and can edit any of the record. I can edit list by double click the cell. Just not able to do with editing form.

Allen Andreas · ‎01-11-2020

Hi,

Can you double check if you have the list_updater role?

Also, can you try clicking "update all" even though you don't want to do that, are the fields read-only there as well?

Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

Khang1 · ‎01-12-2020

Hi Allen,

I have the list_updater role, and tried the 'Update All'. All of the fields in editing form are read-only except for Yes/No fields.

I check with another table in the Compliance application 'sn_compliance_policy' and I can do 'Update Selected/Update All' just fine. It leads me to think there's some thing specific to the 'sn_compliance_policy' that preventing from bulk update.

I also spun up a baseline NY instance on ServiceNow Developers and that table also do the same thing. This is something with the baseline code. (FYI, you have to install the plugin GRC:Policy and Compliance Management to access to the Compliance application.)

Thanks,

Khang