"THIS YEAR" FILTER STUDIO

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

CRM
e-Commerce
Účetnictví
Sklad
PoS
Project
MRP

All apps

All Posts Lidé Odznaky

Štítky (View all)

odoo accounting v14 pos v15

O tomto fóru

Pomoc

"THIS YEAR" FILTER STUDIO

filter filter_domain Filters

1 Odpovědět

3362 Zobrazení

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

Nejlepší odpověď

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

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Přihlásit se

Related Posts	Odpovědi	Zobrazení
Filter by Column filter search Filters	3 lis 24	1149
how to add drop-down view in filter filter dropdownlist Filters v14	0 říj 23	1424
How to set filter on a pre-defined field of another model filter override filter_domain odoo16features	3 srp 23	2876
How to filter o2m invoice_line_ids field values on invoices? filter o2m invoice.line filter_domain	3 zář 20	5955
Using tags as filter value filter tags filter_domain V10	0 led 18	5260

This question has been flagged

Enjoying the discussion? Don't just read, join in!