From 24907b0ab9ad83bf97ac84dc81c14b9eccd8f75a Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Mon, 23 Jan 2023 16:44:25 +0700 Subject: change to materialized view --- indoteknik_custom/models/sale_monitoring_detail.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/indoteknik_custom/models/sale_monitoring_detail.py b/indoteknik_custom/models/sale_monitoring_detail.py index d766cecd..a393f81d 100755 --- a/indoteknik_custom/models/sale_monitoring_detail.py +++ b/indoteknik_custom/models/sale_monitoring_detail.py @@ -22,7 +22,7 @@ class SaleMonitoringDetail(models.Model): def init(self): tools.drop_view_if_exists(self.env.cr, self._table) self.env.cr.execute(""" - CREATE OR REPLACE VIEW %s AS ( + CREATE MATERIALIZED VIEW %s AS ( SELECT *, CASE -- cgit v1.2.3