openerp-india team mailing list archive

["Jignesh Rathod\(OpenERP\)" <1002851@xxxxxxxxxxxxxxxxxx>]

** This bug is no longer a duplicate of bug 1001659
   group by must aggregate function fields

-- 
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/1002851

Title:
  [6.2] Need functional attribute for group

Status in OpenERP Server:
  New

Bug description:
  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().

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