Odoo Help


Group and aggregate in view

Ratmil Torres
on 3/18/15, 3:11 PM 1,050 views

How to group and aggregate in a view?

I have defined a model similar to the following:

   name: char

   group: many2one

   qty: float

   performance: function(float)

I would like to show view displaying group, qty and performance. But the group may be repeated for different records. So, I want to show every group only once, summing qty and performance (which is a function field).

I don´t what to show expandable groups. Just, one line per group.


Serpent Consulting Services Pvt. Ltd.

--Serpent Consulting Services Pvt. Ltd.--
Serpent Consulting Services Pvt. Ltd.
| 6 6 8
Gandhinagar, India
--Serpent Consulting Services Pvt. Ltd.--

Serpent Consulting Services Pvt. Ltd. Your Odoo/OpenERP Solution, just an email away!

Serpent Consulting Services Pvt. Ltd.
On 8/13/15, 4:00 AM


Inside the search View, add a < filter string="Partner" context="{'group_by':'name of may2one field'}"/>

We've added groupby expand feature on Odoo Apps.


Hope this helps.


About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 3/18/15, 3:11 PM
Seen: 1050 times
Last updated: 8/13/15, 4:00 AM