跳至內容
此問題已被標幟
filtercurrentweektodayrelativedelta
2 回覆
14242 瀏覽次數
頭像
Pascal Tremblay

Hello all,

I want to make a filter in a search view.

This filter must accept invoices when their date is in this the current week or the last week.

We consider that the week begins at monday. We consider that the week ends at sunday.

If we are at the beginning of the week actually, we don't go back for 14 days. Current week always begins to the last monday (or the actual monday if we already are monday) and last week always begin to the previous monday. (Do you understand what I mean? Not easy to write it in english...) 

頭像
捨棄
頭像
Pascal Tremblay
作者 最佳答案

I propose this filter :

(monday is weekday 0. sunday is weekday 6)

<filter string="Current and last weeks" name="currentandlastlastweeks" domain="[
        ('date','&gt;=',(context_today()+relativedelta(weeks=-2,days=1,weekday=0)).strftime('%Y-%m-%d')),
        ('date','&lt;',(context_today()+relativedelta(weekday=6)).strftime('%Y-%m-%d'))
                    ]" help="Journal invoices of the current and the last weeks" />


頭像
捨棄
頭像
Ricardo Gross
最佳答案

Hi,

One way would be: Group By > Add Custom Group > "Accounting Date" , and then in Group By > Accounting Date you can select "Week" , and the invoices will be divided between Wxx, Wxy, ...

BR

Ricardo


頭像
捨棄
相關帖文 回覆 瀏覽次數 活動
filter on current week 已解決
filter week
頭像
頭像
頭像
頭像
頭像
4
8月 22
13007
"Today Activities" not filtering correctly
filter today Activities
頭像
0
3月 24
988
How to make a filter for the current and the last month? 已解決
filter current period last
頭像
頭像
2
9月 24
27443
Having to manually clear filters in Odoo version 18 on the webstore shop makes us lose customers
filter
頭像
0
7月 25
882
Filters in multiple companies 已解決
filter
頭像
頭像
1
5月 25
1600