How to stop update from record to Database view?

[Singh3]

Hey,
I have a requirement regarding Database view operation. I have a database view of incident and SLA named "incident_sla". Currently, whenever a SLA gets breached and a new SLA gets tagged to an incident record, a new entry gets created in the DB view. This is helpful for our business to report regarding how much time every group has taken for the incidents. But the problem arises as if the assignment group gets changed on the original incident record, it changes the value of the assignment group in the DB view as well. Can somebody help regarding how not to change it? so that the previous group does not get changed?

Thanks in advance!! 

[AndersBGS]

Hi @Singh3 ,

You can't change this as this is default behavior. A database view is "just" a combination of the incident table and the task table. I would recommend you to look into incident_metric table instead, if the requirement is to see the previous assignment groups.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders