Skip to Content
This question has been flagged
filtersearch
7 Replies
23464 डेटा देखने का तरीका
अवतार
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
Best Answer

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
Best Answer

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

अवतार
खारिज करें
अवतार
Kitti Upariphutthiphong
Best Answer

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
Best Answer

Solution from Miku Laitinen works perfect.

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

Thanks a lot.

अवतार
खारिज करें
अवतार
Antonio Gutierrez
लेखक Best Answer

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

अवतार
खारिज करें
Related Posts Replies डेटा देखने का तरीका ऐक्टिविटी
how can i create a filter that uses the "and" condition
filter search
अवतार
अवतार
अवतार
2
नव॰ 23
5312
filter with related model field Solved
filter search
अवतार
1
अक्तू॰ 20
6817
change search filter Solved
filter search
अवतार
अवतार
2
नव॰ 16
5835
Search with functional fields Solved
filter search
अवतार
अवतार
अवतार
अवतार
अवतार
4
मार्च 15
23197
How to set a new search filter?
filter search
अवतार
अवतार
1
मार्च 15
15617