Odoo Help


How to filter and group with count(*) in OpenERP

on 2/17/15, 6:24 AM 1,457 views


I'm trying to make in OpenERP something like SELECT item1, item2 COUNT(*) FROM table WHERE conditions GROUP BY item1, item2 HAVING COUNT(*) > 5

I have in my tree view:

<field name="domain">CONDITIONS</field>
<field name="context">{'group_by': ['item1', 'item2']}</field>

I figured out that I can use read_group() function to make filtering for COUNT(*) using context['active_ids'] when this view is generated, however it is very slowly and inefficient. Cause I have to iterate through items and look for repetitions by Python.

What are possible solutions in this situations? Better would be to make this whole SELECT by using cursor manualy through wizard, or is there anything like COUNT(*) filtering in OpenERP view syntax?

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

2 follower(s)


Asked: 2/17/15, 6:24 AM
Seen: 1457 times
Last updated: 3/16/15, 8:10 AM