- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-14-2023 01:57 PM
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-14-2023 08:39 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-14-2023 08:39 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-15-2023 06:00 AM
Thank you Maik! Appreciate the information!