Overslaan naar inhoud
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Alle posts Personen Badges
Labels (Bekijk alle)
odoo accounting v14 pos v15
Over dit forum
Deze vraag is gerapporteerd
filtersearch
7 Antwoorden
23084 Weergaven
Avatar
Antonio Gutierrez

Hi.

I have a filter name today with the next value:

<filter string="Today" domain="[('date','>=',((context_today())).strftime('%%Y-%%m-%%d 00:00:00')), ('date', '<=',((context_today())).strftime('%%Y-%%m-%%d 23:59:59'))]"/>

The date field is datetime and the filter work good. The filter return only values from today.

If i save the filter as default filter, openerp save the actual date and the filter not work tomorrow or other day because the date is saved instead of context_today().

Any method to save a filter with the context_today instead of his value?

Thanks. Best regards.

Avatar
Annuleer
Avatar
Miku Laitinen
Beste antwoord

Don't use strftime with hard-coded times. It doesn't take different time zones into account. Instead, use this

<filter name="today" string="Today" 
domain="[('date','>=', datetime.datetime.combine(context_today(), datetime.time(0,0,0))),
         ('date','<=', datetime.datetime.combine(context_today(), datetime.time(23,59,59)))]" />

For example, I'm on UTC+3 now and when I set the min_date of a stock.picking to 2015-05-14 02:00, it's saved to the database as 2015-05-13 23:00. Using strftime in the domain will only work if the min_date is 2015-05-14 03:00 (=2015-05-14 00:00 UTC).

See this commit and this issue.

Avatar
Annuleer
P.V.Anthony

Thank you for sharing this. It has been very useful for me.

Avatar
Anas Taji
Beste antwoord

Try it this way:

<filter string="Today" domain="[('date','&lt;=',time.strftime('%Y-%m-%d 23:59:59')),('date','&gt;=',time.strftime('%Y-%m-%d 00:00:00'))]"/>

Avatar
Annuleer
Avatar
Kitti Upariphutthiphong
Beste antwoord

You will need to go to menu Settings > Technical > User Interface > User-defined filters

There you will see your saved filters in which date already set as specific date.

You need to make the domain here more generic, i.e, 

['date_payment', '<=', time.strftime('%Y-%m-%d 23:59:59')]

Avatar
Annuleer
Avatar
Josean Soroa
Beste antwoord

Solution from Miku Laitinen works perfect.

I'm using v10 but it seems it doesn't matter wich version.

Thanks a lot.

Avatar
Annuleer
Avatar
Antonio Gutierrez
Auteur Beste antwoord

if any answers is given. This can be cataloged as bug.

Avatar
Annuleer
Gerelateerde posts Antwoorden Weergaven Activiteit
how can i create a filter that uses the "and" condition
filter search
Avatar
Avatar
Avatar
2
nov. 23
4962
filter with related model field Opgelost
filter search
Avatar
1
okt. 20
6549
change search filter Opgelost
filter search
Avatar
Avatar
2
nov. 16
5658
Search with functional fields Opgelost
filter search
Avatar
Avatar
Avatar
Avatar
Avatar
4
mrt. 15
23007
How to set a new search filter?
filter search
Avatar
Avatar
1
mrt. 15
15443