İçereği Atla
Bu soru işaretlendi
odoo16features#filter#Sales
2 Cevaplar
1641 Görünümler
Avatar
Anthony

Hello,

I want to add a filter to the sales app that shows the sales orders so far in the current month (updated automatically). That way I can add it to a spreadsheet to make a custom dashboard. 

However I have not been able to create a filter that filters the creation date for the current month automatically.


Can someone help?

Thanks 

Avatar
Vazgeç
Avatar
Mily Shajan
En İyi Yanıt

Hi 

Try this code in search view of sale order 

    

<filter string="Current Month" name="current_month"
        domain="[('create_date','&lt;',(context_today()+relativedelta(months=1)).strftime('%%Y-%%m-01')),
        ('create_date','&gt;=',time.strftime('%%Y-%%m-01'))]"/>


Regards

Avatar
Vazgeç
Anthony
Üretici

Can you send a screenshot of where to put this code?

Thanks!

Avatar
Daniel Alejandro Nieto Barreto (danb)
En İyi Yanıt

If you don't want to edit the view, (in Odoo 17+) in the filter pop-up you can input the following

(you need developer mode on)

The code is

[("date_order", ">", datetime.datetime.combine(context_today(), datetime.time(6, 0, 0)).strftime("%Y-%m-01 %H:%M:%S"))]
Avatar
Vazgeç
İlgili Gönderiler Cevaplar Görünümler Aktivite
Sales Order Follow up Çözüldü
odoo16features #Sales
Avatar
Avatar
Avatar
2
Eyl 23
1871
Disable 'create' suggestions in the 'sales quotations' add new product or customer Çözüldü
odoo16features #Sales
Avatar
Avatar
1
Şub 24
1218
How to filter records in tree view based on selected company in Odoo v16 ? Çözüldü
odoo16features #filter #records #domain
Avatar
Avatar
1
Ara 23
4666
How to add @api.onchange in _get_view() method odoo 16
odoo16features
Avatar
Avatar
1
May 25
1984
get all partners which are internal users or portal users odoo16
odoo16features
Avatar
Avatar
1
Nis 25
3043