跳至内容
此问题已终结
odoo16features#filter#Sales
2 回复
1757 查看
形象
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 

形象
丢弃
形象
Mily Shajan
最佳答案

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

形象
丢弃
Anthony
编写者

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

Thanks!

形象
Daniel Alejandro Nieto Barreto (danb)
最佳答案

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"))]
形象
丢弃
相关帖文 回复 查看 活动
Sales Order Follow up 已解决
odoo16features #Sales
形象
形象
形象
2
9月 23
1992
Disable 'create' suggestions in the 'sales quotations' add new product or customer 已解决
odoo16features #Sales
形象
形象
1
2月 24
1301
How to filter records in tree view based on selected company in Odoo v16 ? 已解决
odoo16features #filter #records #domain
形象
形象
1
12月 23
4831
How to add @api.onchange in _get_view() method odoo 16
odoo16features
形象
形象
1
5月 25
2212
get all partners which are internal users or portal users odoo16
odoo16features
形象
形象
1
4月 25
3256