Odoo Help

Welcome!

This community 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.

4

how to remove sum of total in group by

By
Prakash
on 8/30/13, 7:40 AM 6,698 views

In OpenERP 7 List view time data added using the below code:-

'in_time' : fields.float('In Time'),

<field name="intake_time" widget="float_time"/>

In List view selected "Group by " any fields Header shows Total In time Value

How to remove Total In time value ? [in xml file not added sum keyword but group by still shows sum time ]

3
Pierre verkest
On 9/26/14, 5:35 PM

Hi,

Probably a bit late!

You could override the read_group method like this on you model:

    def read_group(self, cr, uid, domain, fields, groupby, offset=0, limit=None, context=None, orderby=False):
        if 'intake_time' in fields:
            fields.remove('intake_time')
        return super(MyClassName, self).read_group(cr, uid, domain, fields, groupby, offset, limit=limit, context=context, orderby=orderby)

I let a 'c' on the if condition, unfortunately, I haven't enough karma to edit my own post!...

Pierre verkest
on 9/26/14, 5:38 PM

I completely agree with this method, I tried it and it works! Thank you.

Karina Delgado
on 10/2/14, 2:02 PM

Thanks for this tip. It still work in Odoo 8.0

Camptocamp SA, Yannick Vaucher
on 11/25/14, 7:11 AM

By the way I fixed the extra 'c'

Camptocamp SA, Yannick Vaucher
on 11/25/14, 7:14 AM

Not too late at all. Thanks. Still works on Odoo 9.0.

Mathieu Laflamme
on 8/26/16, 4:31 PM

Ok after struggling with another issue on the pivot view, I figured out this hack is causing problem... seems like the pivot view is confused on the groups and javascript is crashing when selecting measures or "Expand all". I think the js code can be fixed to fully support the hack here and I will fill a ticket at Odoo.

Mathieu Laflamme
on 8/29/16, 3:35 PM

There is no issue with the pivot finally!!! Problem is that last line should be:

return super(ReportDetailInvoice, self).read_group(cr, uid, domain, fields, groupby, offset, limit, context, orderby, lazy).

Mathieu Laflamme
on 8/29/16, 5:39 PM
0

Prakash

--Prakash--
3173
| 5 4 7
Bikaner, India
--Prakash--

OpenERP Devloper at SunARC Technology

Prakash
On 9/6/13, 6:01 AM

The default Float field value for group_operator shows sum of value

Reference link http://www.zbeanztech.com/blog/group-operator-openerp-grouping

Currently "Group by" Field values able to change to min, max, avg

But unable to remove group by value

i applied group_operator = None or group_operator = False but its still shows sum of total. How to group_by remove sum or set to value None

Any update?..

0

Francesco OpenCode

--Francesco OpenCode--
3608
| 5 7 9
Grottaglie, Italy
--Francesco OpenCode--

Italian Odoo (OpenERP) Modules Developer LINKEDIN: http://www.linkedin.com/in/francescoapruzzese

Francesco OpenCode
On 8/30/13, 11:26 AM

If the field has the tag sum in the tree view, when you use the group by you have the sum of all records. Remove the sum tag from view so you has'nt the sum when use group by

0

Naresh Soni (nch)

--Naresh Soni (nch)--
Tiny ERP Pvt Ltd
http://www.odoo.com
1281
| 2 2 4
India
--Naresh Soni (nch)--

Team Lead, Odoo(Formerly OpenERP) Support & OPW

Naresh Soni (nch)
On 9/25/13, 6:52 AM

Hello Prakash,

By default OpenERP Will consider 'SUM' as group operator . So you wan't be able to remove this behavior easily by any sort of configuration or xml code. For this you need to make changes in the orm.py in def read_group method and comment out the code that adds the default 'SUM' to integer and float fields at line 2664.

Hope this helps !

Thanks for reply i will try

Prakash
on 9/25/13, 7:41 AM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 8/30/13, 7:40 AM
Seen: 6698 times
Last updated: 5/6/16, 10:50 AM