UI Action 'Delete All Records' on sys_db_object does not work for scoped tables showing the error "Delete operation against 'x_snc_int3519265_2_table' from scope 'rhino.global' has been refused due to the table's cross-scope access policy" - Known Error

UI Action 'Delete All Records' on sys_db_object does not work for scoped tables showing the error "Delete operation against 'x_snc_int3519265_2_table' from scope 'rhino.global' has been refused due to the table's cross-scope access policy" Description The 'Delete All Records' UI Action does not work for scoped tables for which the 'Delete' action has not been made accessible to all scopes. This is regardless of the current user's selected scope in the Scope Picker. An error like: the following is displayed, when the user attempts to use "Delete All Records" on a scoped table: " Delete operation against 'x_snc_int3519265_2_table' from scope 'rhino.global' has been refused due to the table's cross-scope access policy "

Steps to Reproduce

Create a new scoped application or use an existing one, set the scoped application as your current 2. Create a new table, make sure the tab Application Access has the option "Accessible from" set to "This application scope only" 3. Add a few records into the new table 4. Go to the table form and try "Delete All Records" button, insert "delete" keyword on the dialog

The table records are not deleted and the error below appears on screen: " Delete operation against 'x_snc_int3519265_2_table' from scope 'rhino.global' has been refused due to the table's cross-scope access policy "

Workaround This is the scope system working as intended by design. The "Delete All Records" UI Action is defined in the global scope, and calls a Script Include named "RecordUtils" in the global scope. This Script Include, in turn, calls the GlideRecord scripted API to query the selected table, then calls the "deleteMultiple" method on the GlideRecord result set.

If the selected table has not been explicitly set to allow all scopes to delete records from it, and the table is defined in a scope other than global, then the delete will fail. To delete all records from a table, the user can:

Go to Scripts - Background in their instance, or create a Fix Script. Select the scope that the table is defined in, in the scope-picker (either the one provided at the bottom of the Scripts - Bakcground script window, or in the platform Scope Picker before creating the new Fix Script) Enter a script like below var records = new GlideRecord("insert tabe name here"); if (!records.isValid()) return; if(!records.canDelete()) return; records.query(); var count = records.getRowCount(); gs.info("Deleting {0} records", count); records.deleteMultiple(); 4. Run the script.