Odoo Server (MOVED TO GITHUB)

lp:~numerigraphe/openobject-server/trunk-read_group-having

Created by Numérigraphe on 2012-05-03 and last modified on 2013-07-18

Abandoned because refused upstream, but other ways were probably implemented in between

This branch adds a new parameter named "having" to orm.read_group(), that lets clients pass the information to filter the grouped records based on the sum (or avg, etc.) of a value.
This parameter should contain a domain-like list of tuples, that the ORM will use to add a "HAVING" clause to the SQL query.

For an example of how this feature is useful, please see lp:~numerigraphe/openobject-addons/trunk-stock-analysis-filter-zero, where we use the "having" parameter to filter out results with quantity = 0 in stock analysis. This can only be done after the records have been grouped (the goods may have gone in then out of a location).

This is only really useful if clients support it too. Support for the GTK client has been added in lp:~numerigraphe/openobject-client/trunk-read_group-having.

Get this branch:: bzr branch lp:~numerigraphe/openobject-server/trunk-read_group-having

Only Numérigraphe can upload to this branch. If you are Numérigraphe please log in for upload directions.

Branch merges

No branches dependent on this one.

Rejected for merging into lp:openobject-server

OpenERP Framework Experts: Pending requested 2012-05-03

OpenERP Core Team: Pending requested 2012-05-03

Wishlist

Won't Fix

Link a bug report

Related blueprints

Branch information

Owner:: Numérigraphe

Project:: Odoo Server (MOVED TO GITHUB)

Status:: Abandoned

Recent revisions

4151. By Numerigraphe - Lionel Sausin <email address hidden> on 2012-06-05

[FIX] properly initialize context and having in read_group()

4150. By Philippe Rossi & Lionel Sausin on 2012-05-03

[IMP] orm: add a 'having' parameter to read_group() to filter grouped records

4149. By Launchpad Translations on behalf of openerp on 2012-04-26