"THIS YEAR" FILTER STUDIO

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

CRM
e-Commerce
Księgowość
Zapasy
PoS
Project
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

"THIS YEAR" FILTER STUDIO

filter filter_domain Filters

1 Odpowiedz

3375 Widoki

Carlos Sánchez

I want to create a relative filter with studio in which it shows me, for example, THIS YEAR'S invoices.

I have managed to create relative filters, for example, to TODAY's date minus x days:

["&",["create_date",">=",datetime.datetime.now()-datetime.timedelta(days=365)],["create_date","<=",datetime.datetime.now() ]]

NOTE: I know that filter comes by default. But I need to create a new one that shows me the invoices for this year. I have a pivot view on my dashboard and I want it to automatically change every year. If I use that filter, the dashboard view will not change to 2023.

But I don't know how to create a filter for THIS YEAR, can you help me?

Thank you very much community!

Waleed Ali Mohsen

Najlepsza odpowiedź

Hi, You can use the below to add filters:

For Today:

<filter string="Today" name="today" domain="[('craete_date', '&gt;=', datetime.datetime.now().strftime('%Y-%m-%d 00:00:00')),('craete_date', '&lt;=',datetime.datetime.now().strftime('%Y-%m-%d 23:59:59'))]"/>

for This Year filter:

<filter string="This Year" name="year" domain="[('craete_date','&lt;=', time.strftime('%%Y-12-31')),('craete_date','&gt;=',time.strftime('%%Y-01-01'))]"/>

Carlos Sánchez

Autor

Thank you very much!!! I have been blocked for days and trying to get the magic formula and you have helped me a lot. I sincerely thank you very much for your answer, you have helped me a lot.

Finally what I was looking for was this:

[('invoice_date','<=', time.strftime('%%Y-12-31')),('invoice_date','>=',time.strftime('%%Y-01-01'))]

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
Filter by Column filter search Filters	3 lis 24	1160
how to add drop-down view in filter filter dropdownlist Filters v14	0 paź 23	1440
How to set filter on a pre-defined field of another model filter override filter_domain odoo16features	3 sie 23	2895
How to filter o2m invoice_line_ids field values on invoices? filter o2m invoice.line filter_domain	3 wrz 20	5964
Using tags as filter value filter tags filter_domain V10	0 sty 18	5267

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!