İçereği Atla
Bu soru işaretlendi
filtersearch
7 Cevaplar
21569 Görünümler
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
Vazgeç
Avatar
Miku Laitinen
En İyi Yanıt

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
Vazgeç
P.V.Anthony

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

Avatar
Anas Taji
En İyi Yanıt

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
Vazgeç
Avatar
Kitti Upariphutthiphong
En İyi Yanıt

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
Vazgeç
Avatar
Josean Soroa
En İyi Yanıt

Solution from Miku Laitinen works perfect.

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

Thanks a lot.

Avatar
Vazgeç
Avatar
Antonio Gutierrez
Üretici En İyi Yanıt

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

Avatar
Vazgeç
İlgili Gönderiler Cevaplar Görünümler Aktivite
how can i create a filter that uses the "and" condition
filter search
Avatar
Avatar
Avatar
2
Kas 23
3935
filter with related model field Çözüldü
filter search
Avatar
1
Eki 20
5533
change search filter Çözüldü
filter search
Avatar
Avatar
2
Kas 16
4744
Search with functional fields Çözüldü
filter search
Avatar
Avatar
Avatar
Avatar
Avatar
4
Mar 15
21747
How to set a new search filter?
filter search
Avatar
Avatar
1
Mar 15
14257