List editing on Database Views

[richard_selby]

Are views just like any other table when it comes to updating?
Some of our most useful tables in the system are actually views, made with the database views module.
Can a user perform a list edit operation on a view and make bulk updates to the underlying tables?
It seems to me that they can't. The ACLs don't seem to work in the same way as a base table.
Or is there some setting to allow this, e.g. update_views ?

[michael_baker]

Richard,

I submitted an incident with ServiceNow back in November of 2012 asking them how to allow list editing within a Database View list and their response was: "Unfortunately the code to do this is source code and is not accessible to our customers. I will submit and enhancement request." They opened an enhancement request, FTASK15562, but I have not heard of any progress on this.

My suggestion is to also submit an incident with ServiceNow asking for this feature. Perhaps this will spur them to include it in a future release.

Hope this helps!

[sbungener]

Hello,

I am pretty new with ServiceNow and we are two months live with our implementation.
I am still correcting data once in a while and educating staff.

When doing a list editing a simple view, say all Incidents, this works for the field 'Incident type' but not on the field Configuration Item.

Is the above discussion similar as the issue I have?
If not can you help me?

Regards,
Sander

[richard_selby]

And now they have two enhancement requests - I raised FTASK17165 asking for the fucntionality

[richard_selby]

A restriction that one often bumps against is SN only lets you edit one field from a derived table at once. So you might be able to edit, for example, the UP address of one CI from list view, but not two. However, if it is the name of the CI, you should be able to edit that, as this is just a reference to a third party table. Perhaps an ACL restriction?