Odoo 12 Development Essentials - Fourth Edition

Pivot views

The data can also be seen in a pivot table, a dynamic analysis matrix. For this, we have the pivot view.

Changed in Odoo 9Pivot tables were already available in Odoo 8, as a graph view feature. In Odoo 9, they were moved to their own view type. Along with this, the pivot table features were improved, and the retrieval of pivot table data was optimized.

Data aggregations are only available for database stored fields. We want to use the num_books field to present some statistics on the number of borrowed books. It's a computed field and isn't being stored right now. To have it available for these views, we need to first have it stored in the database, by adding the store=True attribute:

    num_books = fields.Integer( compute='_compute_num_books', ...