Why? List-View Editing Disabled OOTB for Reports [sys_report] Table

JosephW1
Tera Guru

This question has arisen because I have many tasks where it would be very helpful if I enabled list-view editing for the Report [sys_report] table. By default, list-view editing is disabled on this table, though I have not been able to find any documentation on this restriction or why it was done.

 

QUESTION: What necessitated this list-view edit restriction on the Report [sys_report] table? As I'm sure there is a good reason, and I don't want to make more problems than I resolve by disabling this restriction.

As Adam Stout mentioned, the report table is loaded with dependent fields dependent on the report type, so building a report from the list could be quite complicated. Disabling it across-the-board would avoid the necessity of complex documentation/questions/answers on how to set/troubleshoot records users have modified via the list interface.

I get it that users could get lost/make a mess in the list view interface, but it is also capable as serving as a valuable config tool. I would think that a role-based list-view edit constraint could be beneficial for reports administration. That is, unless I'm overlooking something. That is precisely what I made this question to verify. And to figure out how to enable it, too, if appropriate.

Are there any other reasons that it is disabled?



 Thank you for your time!

 

 List-view edit example
find_real_file.png

1 ACCEPTED SOLUTION

JosephW1
Tera Guru

As brought up by @Chuck Tomasi and @Adam Stout, allowing list-view editing on the Report [sys_report] table should be done with extreme caution. I personally only recommend enabling this feature if you comprehend the risk and are able to identify someone that can truly be trusted with this privilege.

To Enable List-View Editing:

In the List Control menu for the Reports [sys_report] table, change the List edit type setting to Save immediately (cell edit mode). Save the settings.

 find_real_file.png

 

 

To Role-Constrain List-View Editing:

Enable list-view editing (above) and then reproduce the following ACL to restrict list-view editing on the Report [sys_report] table to admins and report_admins only. (Thank you @Chuck Tomasi)

find_real_file.png

View solution in original post

11 REPLIES 11

JosephW1
Tera Guru

To Enable List-View Editing:

In the List Control menu for the Reports [sys_report] table, change the List edit type setting to Save immediately (cell edit mode). Save the settings.

 

 

 

To Role-Constrain List-View Editing:

Enable list-view editing (above) and then reproduce the following ACL to restrict list-view editing on the Report [sys_report] table to admins and report_admins only.

JosephW1
Tera Guru

As brought up by @Chuck Tomasi and @Adam Stout, allowing list-view editing on the Report [sys_report] table should be done with extreme caution. I personally only recommend enabling this feature if you comprehend the risk and are able to identify someone that can truly be trusted with this privilege.

To Enable List-View Editing:

In the List Control menu for the Reports [sys_report] table, change the List edit type setting to Save immediately (cell edit mode). Save the settings.

 find_real_file.png

 

 

To Role-Constrain List-View Editing:

Enable list-view editing (above) and then reproduce the following ACL to restrict list-view editing on the Report [sys_report] table to admins and report_admins only. (Thank you @Chuck Tomasi)

find_real_file.png

Exercise EXTREME caution when doing this on tables like sys_report. As noted earlier, it was disabled for a reason.

Thanks again Chuck. Limiting this ability to report_admins who understand the sensitivity of this action equates to "EXTREME" caution, wouldn't you say?

Furthermore, the list-view (Reports > Administration) of the Report [sys_report] table is rather locked down itself - it only appears in the navigation menu for users with the role of report_admin.

Does anyone have any official documentation on the risk of enabling this feature? It would be nice to have the reasons quantified instead of having an unstated reason. It's hard to reason with or evaluate an unstated reason.

@Adam Stout any thoughts on who might have a defined reason why list editing is not available on sys_report?