跳至內容
選單
此問題已被標幟
2 回覆
1809 瀏覽次數

For example, how do we aggregate the records of invoices from account.move and records of expenses from hr.expense to a new different model model.new.

The goal is to be able to access these records and create report tables/charts...

頭像
捨棄
作者 最佳答案

Thanks Niyas Raphy for the support, the video answered it but one need to make some edit for newer Odoo version. Here is my working test code.

product_id = fields.Many2one('product.product')
invoice_date = fields.Date()

@api.model
def init(self):
tools.drop_view_if_exists(self.env.cr, 'cashflow_actual')
self.env.cr.execute("""​ CREATE OR REPLACE VIEW cashflow_actual AS (
​SELECT row_number() OVER () AS id, aml.product_id, am.invoice_date
​FROM account_move_line aml
​LEFT JOIN account_move am ON (am.id = aml.move_id)
​)
""")
頭像
捨棄
最佳答案

Hi,

You can go through this video, which explains about the db view: Create Model/DB View Using Query In Odoo || Combine Multiple Model Into One Model

Thanks

頭像
捨棄
相關帖文 回覆 瀏覽次數 活動
3
8月 25
2580
1
5月 25
2623
1
4月 25
3604
1
4月 25
4471
1
4月 25
1929