Group by function fields does not work properly in web.

[Ferdinand]

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

[wowas (wowas18)]

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().

[Jignesh Rathod(OpenERP) (jir-openerp)]

Hello Ferdinand ,

I have checked this issue at my end.Currently It display a sum for function field.
So as per your bug description ("does not compute sums when use groupby ")
It only affect web client , First 2 times it display a sum of function field and
and then sum is disappear in web. Gtk works fine.so i assign this issue to web
team.

I have attached a video for both web and Gtk client.

Thanks you!

[Ferdinand (office-chricar)]

Hmm, I do not understand why group by is solved in the client ?

BTW
when I think it's a (web)client problem I am told it's a server issue
now it's a client issue

[wowas (wowas18)]

Now (from 6.1) web side it's addon of OpenERP, that in the main javascript code, that execute in browser.

[Dawn Richardson (r-dawn)]

Hi, this issue still seems to be effecting the current release. Unsure why it has been marked as invalid. The minor issue in mentioned in comment #4, with totals going blank when the arrow is clicked twice, is still broken.

Also, the sum of some groupings does not work for all objects. I haven't worked out a consistent pattern in the ones which it fails on, but an example is account.account. Navigating to Account > Configuration > Accounts > Accounts and grouping by anything, such as "Account Type", will result in Debit, Credit and Balance being blank.

Any explanations or further evaluation of this bug would be appreciated.

[Ferdinand (office-chricar)]

it affects 7.0 too

[Dawn Richardson (r-dawn)]

Ah, it seems only function fields with the "store" parameter set can be summed up. Is that the expected behavior?

[Ferdinand (office-chricar)]

that is what it does, but there are many "important" function fields in accounting, stock, project etc which can't be stored and hence are ignored or not suitable for grouping and sorting.

we have created a patch for 6.0 which allows (at least) sorting of function fields, but no one was interested in implementing in official branch

[Fabian Semal (fabian.semal)]

Hello,

Any news on that issue ?

Regards,

Fabian

[Yann Papouin (yann-papouin)]

In the same way, I have a stored field that allow to know the picked_rate for production orders. Using a progressbar as widget displays a percent value > 100 when using GroupBy.

[bruno bottacini (bruno-bottacini)]

I created a widget but unfortunately requires a patch to view_list.js
lp:~bruno-bottacini/+junk/7.0-web_calc