Hoppa till innehåll
Du måste vara registrerad för att kunna interagera med communityn.
Alla inlägg Personer Utmärkelser
Etiketter (Visa alla)
odoo accounting v14 pos v15
Om detta forum
Denna fråga har flaggats
filtersearch
7 Svar
23233 Vyer
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
Avbryt
Avatar
Miku Laitinen
Bästa svar

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

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

Avatar
Anas Taji
Bästa svar

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
Avbryt
Avatar
Kitti Upariphutthiphong
Bästa svar

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
Avbryt
Avatar
Josean Soroa
Bästa svar

Solution from Miku Laitinen works perfect.

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

Thanks a lot.

Avatar
Avbryt
Avatar
Antonio Gutierrez
Författare Bästa svar

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

Avatar
Avbryt
Relaterade inlägg Svar Vyer Verksamhet
how can i create a filter that uses the "and" condition
filter search
Avatar
Avatar
Avatar
2
nov. 23
5045
filter with related model field Löst
filter search
Avatar
1
okt. 20
6598
change search filter Löst
filter search
Avatar
Avatar
2
nov. 16
5726
Search with functional fields Löst
filter search
Avatar
Avatar
Avatar
Avatar
Avatar
4
mars 15
23047
How to set a new search filter?
filter search
Avatar
Avatar
1
mars 15
15483