The CreatorCon Call for Content is officially open! Get started here.

Is there a way to edit fields from a database view report?

megw
Tera Contributor

We have created a database view between the demand and demand task tables, created some reports from that dbv table and placed them on a dashboard. The dashboard users would like to be able to edit some fields (task or demand description, task or demand work notes) directly from the report. Currently when we double click on the field from the report it comes up with the 'security prevents writing to this field' message. Users are able to open the record and edit the field. They are also able to edit that field directly from a report that was built on either the demand table or the demand task table - just not from the database view. Is there a way to to open up these fields to be editable from the report, or is that something that is locked down for database view reports?

1 ACCEPTED SOLUTION

Maik Skoddow
Tera Patron
Tera Patron

Hi @megw 

as you can read on https://docs.servicenow.com/bundle/utah-platform-administration/page/use/reporting/concept/c_Databas... 


A database view defines table joins for reporting purposes.

 

By nature, a database view is just a copy of the underlying joined tables and therefore you cannot edit these values.

 

But when clicking on one of the referenced records in the list view of a database view you are forwarded to the original record and thus are able to edit it.

 

Maik

View solution in original post

2 REPLIES 2

Maik Skoddow
Tera Patron
Tera Patron

Hi @megw 

as you can read on https://docs.servicenow.com/bundle/utah-platform-administration/page/use/reporting/concept/c_Databas... 


A database view defines table joins for reporting purposes.

 

By nature, a database view is just a copy of the underlying joined tables and therefore you cannot edit these values.

 

But when clicking on one of the referenced records in the list view of a database view you are forwarded to the original record and thus are able to edit it.

 

Maik

megw
Tera Contributor

Thank you Maik!  Appreciate the information!