Odoo Help

2

How to group by day with a filter on datetime field

By
Antanas
on 7/28/13, 2:13 PM 2,399 views

I would like to create a filter for grouping by day, the filter would be applied on 'datetime' field.

I have tried this:

<filter string="Day"
    icon="terp-go-today"
    domain="[
            ('timestamp','&lt;=', (time.strptime(timestamp,'%%Y-%%m-%%d %%H:%%M:%%S') + relativedelta(day=1)).strftime('%%Y-%%m-%%d %%H:%%M:%%S')),
             ('timestamp','>=', (time.strptime(timestamp,'%%Y-%%m-%%d %%H:%%M:%%S') - relativedelta(day=1)).strftime('%%Y-%%m-%%d %%H:%%M:%%S'))
                       ]"
    context="{'group_by':'timestamp'}"/>

But no positive result, I only get

TypeError: results.group_by is undefined

It loooks like 'timestamp' field does not get evaluated after comparison operator. Any ideas on how to implement this?

About This Community

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

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)

Stats

Asked: 7/28/13, 2:13 PM
Seen: 2399 times
Last updated: 3/16/15, 8:10 AM