I want to create a user defined filter to filter events ocurring in the next 7 days
used the folowing code
[('date','<=', ((context_today()-datetime.timedelta(days=7)).strftime('%Y-%m-%d')))],[('date','>=', context_today())]
I tried a simple
[['date', '>=', context_today()]]
and it dint worked either...
For Events, there is no field date, you should use date_begin
[('date_begin','>=', ((context_today()).strftime('%Y-%m-%d'))), ('date_begin','<=', ((context_today()+datetime.timedelta(days=7)).strftime('%Y-%m-%d')))]
I also had same requirement, for 3 days...
So I used functional field say next_7th_date, which will calculated the date (in your case 7th day from date) and saved it in db...
Then used it in XML search view like this
<filter name="next_7th_date" domain="[('next_7th_date', '>', current_date)]" ...../>
somehow we have to refresh to reload the filter...
under the user defined filters the following code works!
['date', '>=', context_today().strftime('%Y-%m-%d')],
['date', '<', (context_today() + datetime.timedelta(7)).strftime('%Y-%m-%d')],
With the advantage of having all the data. Filters are a more convenient way than xml search
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 9/18/14, 5:56 AM|
|Seen: 1054 times|
|Last updated: 3/16/15, 8:10 AM|