Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Boekhouding
Voorraad
PoS
Project
MRP

All apps

Alle posts Personen Badges

Labels (Bekijk alle)

odoo accounting v14 pos v15

Over dit forum

Help

How to save a filter with today value from context

filter search

7 Antwoorden

21732 Weergaven

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.

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.

P.V.Anthony

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

Anas Taji

Try it this way:

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

walaa

Kitti Upariphutthiphong

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')]

Josean Soroa

Solution from Miku Laitinen works perfect.

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

Thanks a lot.

Antonio Gutierrez

Auteur

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

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden

Gerelateerde posts	Antwoorden	Weergaven
how can i create a filter that uses the "and" condition filter search	2 nov. 23	4043
filter with related model field Opgelost filter search	1 okt. 20	5633
change search filter Opgelost filter search	2 nov. 16	4843
Search with functional fields Opgelost filter search	4 mrt. 15	21867
How to set a new search filter? filter search	1 mrt. 15	14355

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!