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

CRM
e-Commerce
Akuntansi
Inventaris
PoS
Project
MRP

All apps

Semua Post Orang Lencana-Lencana

Label (Lihat semua)

odoo accounting v14 pos v15

Mengenai forum ini

Help

How to save a filter with today value from context

filter search

7 Replies

21786 Tampilan

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

Jawaban Terbai

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

Penulis

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

Menikmati diskusi? Jangan hanya membaca, ikuti!

Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!

Daftar

Post Terkait	Replies	Tampilan
how can i create a filter that uses the "and" condition filter search	2 Nov 23	4086
filter with related model field Diselesaikan filter search	1 Okt 20	5646
change search filter Diselesaikan filter search	2 Nov 16	4861
Search with functional fields Diselesaikan filter search	4 Mar 15	21943
How to set a new search filter? filter search	1 Mar 15	14382

Pertanyaan ini telah diberikan tanda

Menikmati diskusi? Jangan hanya membaca, ikuti!