Меню

Допомога

0

How can i get a computed field in pivot view?

Avatar
Nihal KC

I'm trying to create a pivot view of pricelists, which gives a clear report on every pricelists and their items. But as some of the fields in the 'product.pricelist.item' model is computed fields and not stored I cannot access them in pivot view. Can anybody give me an idea how to achieve this ?

1 Коментар
Аватар
Відмінити
Avatar
Nihal KC
-

Hi Kiran, I don't have enough points to add a comment to your answer so I'm writing my reply here. I had tried by adding the attribute 'store=True', but this makes all the existing data to be empty and once i edit and save them again the value is returned.

1 Відповідь
2
Avatar
Kiran Mohan
Найкраща відповідь

Hi , 

Computed fields which are not stored in database cannot be used in Pivot Views

add the attribute  store=True  

price_subtotal = fields.Monetary(string='Amount',
store=True, readonly=True, compute='_compute_subtotal')

Hope it Helps,
Kiran K

Аватар
Відмінити