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

CRM
e-Commerce
Бухгалтерия
Склад
PoS
Проекты
MRP

All apps

Все посты Люди Значки

Теги (Смотреть все)

odoo accounting v14 pos v15

Об этом форуме

Помощь

How to save a filter with today value from context

filter search

7 Ответы

21839 Представления

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

Лучший ответ

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

Автор

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

Не оставайтесь в стороне – присоединяйтесь к обсуждению!

Создайте аккаунт сегодня, чтобы получить доступ к эксклюзивным функциям и стать частью нашего замечательного сообщества!

Регистрация

Похожие посты	Ответы	Просмотры
how can i create a filter that uses the "and" condition filter search	2 нояб. 23	4110
filter with related model field Решено filter search	1 окт. 20	5661
change search filter Решено filter search	2 нояб. 16	4873
Search with functional fields Решено filter search	4 мар. 15	21997
How to set a new search filter? filter search	1 мар. 15	14400

Этот вопрос был отмечен

Не оставайтесь в стороне – присоединяйтесь к обсуждению!