openerp-india team mailing list archive

[wowas <1001659@xxxxxxxxxxxxxxxxxx>]

It is very difficult made GROUP BY in TREE VIEW or in GRAPH VIEW, if field calculate from other fields.
For example we have table with following fields:
date (Date of production)
prod_qty (Total Quantity produced items)
reject_qty (Quantity of rejected items)
quality (Calculated field: quality = reject_qty/prod_qty)

If we try GROUP BY 'date' then for some date we get:

PROD_QTY = SUM(prod_qty of the same date)
REJECT_QTY = SUM(reject_qty of the same date)
QUALITY = SUM(quality of the same date)

But for agregate QUALITY = REJECT_QTY/PROD_QTY = SUM(reject_qty of the same date)/SUM(prod_qty of the same date)
Because it no the same as SUM(quality of the same date), need add extra code (for example rewrite function read_group())

It will be more cool if we have functional attribute for field, that
will describe custom agregate function other than SUM().

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Server.
https://bugs.launchpad.net/bugs/1001659

Title:
  group by must aggregate function fields

Status in OpenERP Server:
  New

Bug description:
  currently the "group by" does not compute sums for function fields
  (custom module)

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-server/+bug/1001659/+subscriptions