Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
4 Odpovědi
11849 Zobrazení

I'd like to have a dashboard that shows me (for example) QC Inspections that were created in the current month.  Is there a way to filter dates this way?

Avatar
Zrušit
Nejlepší odpověď


It should work... Let us know ...

[('create_date', '>', (datetime.datetime.now()).strftime('%Y-%m-01') )]

Avatar
Zrušit
Nejlepší odpověď

1 - Go to the listing where you want to add a filter.
2 - Open Studio, and add a new filtrer.
Define any filter domain. Not important now.
We don't care about the values filtered, because we will edit later.
This will create a new vue with this filter.

3 - Activate the developper mode, and access to the Vues.
Filter to the vues with date created = today to find your last view.
If you edit a filter in the quotations, you will find a view inherited to 

sale.order.search.inherit.quotation



4 - Edit the view and put exactly what you want.
For example : filter on last 7 days

string="7 derniers jours" 

domain="[("date_order","=",(datetime.date.today()-datetime.timedelta(days=7)).strftime("%Y-%m-%d 00:00:00"))]"/>


Inside the domain, you need to write in html.
For example &quote  instead of " or &gt instead of >


Avatar
Zrušit
Nejlepší odpověď

Hello,

Try this

<filter icon="terp-check" string="Current Date" name="current_date" domain="[('date','=',((context_today()).strftime('%%Y-%%m-%%d')))]"/>

hope it help

Avatar
Zrušit
Nejlepší odpověď

Add a filter to your view similar to this one...

<filter icon="terp-go-today" string="This Month" domain="[('date','<=',context_today().strftime('%%Y-%%m-%%d')),('date','>=',context_today().strftime('%%Y-%%m-01'))]"/>


You need context_today to use the "user" timezone" when calculating the dates...

Avatar
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
2
bře 25
5932
0
pro 24
1021
2
led 24
1751
1
zář 23
1412
0
úno 25
1425