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

CRM
e-Commerce
Contabilità
Magazzino
PoS
Progetti
MRP

All apps

Tutti gli articoli Persone Badge

Etichette (Mostra tutto)

odoo accounting v14 pos v15

Sul forum

Assistenza

How to save a filter with today value from context

filter search

7 Risposte

21565 Visualizzazioni

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

Risposta migliore

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

Autore

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

Ti stai godendo la conversazione? Non leggere soltanto, partecipa anche tu!

Crea un account oggi per scoprire funzionalità esclusive ed entrare a far parte della nostra fantastica community!

Registrati

Post correlati	Risposte	Visualizzazioni
how can i create a filter that uses the "and" condition filter search	2 nov 23	3933
filter with related model field Risolto filter search	1 ott 20	5532
change search filter Risolto filter search	2 nov 16	4744
Search with functional fields Risolto filter search	4 mar 15	21741
How to set a new search filter? filter search	1 mar 15	14257

La domanda è stata contrassegnata

Ti stai godendo la conversazione? Non leggere soltanto, partecipa anche tu!