diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2023-01-23 16:44:25 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2023-01-23 16:44:25 +0700 |
| commit | 24907b0ab9ad83bf97ac84dc81c14b9eccd8f75a (patch) | |
| tree | 172ec650955091f5cacb1f40ac65896150fe8eb5 | |
| parent | 8af5ee591aabc2d5d946c0eece93a5caab989975 (diff) | |
change to materialized view
| -rwxr-xr-x | indoteknik_custom/models/sale_monitoring_detail.py | 2 |
1 files changed, 1 insertions, 1 deletions
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 |