Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

4

Filter by date of today with a delay

By
Wided
on 3/26/13, 7:05 AM 10,811 views

Hello, When creating a filter in the client, how can I indicate in the domain to filter on the stock moves before (the date of today - 10 days) for example? I tried different expressions but that didn't work. Thanks.

Now, I'd like to use this filter in a campaign segment. When I click on the "synchronize" button, I get an error "NameError: name 'context_today' is not defined". I don't understand why does this work only in sale order line view. Do you have any idea?

Wided
on 3/31/14, 6:51 AM
6

Andreas Brueckl

--Andreas Brueckl--
5056
| 7 8 7
Vienna, Austria
--Andreas Brueckl--
OpenERP Consulting and Development
Andreas Brueckl
On 3/26/13, 8:01 AM

The model stock.move uses a timestamp value for field date. The following domain should return all moves where the date is earlier than today - 10 days:

[('date','<=', ((context_today()-datetime.timedelta(days=10)).strftime('%Y-%m-%d')))]

I assume, that you use the domain in a window action. If you want to use it in a view, you should use &lt;= instead of <=.

Thank you very much, that worked.

Wided
on 3/26/13, 8:14 AM

+1 for this good answer As said Francesco, in a view you need to escape the % using %%

Camptocamp SA
on 4/23/13, 10:36 AM

Hello, you used the context_today () like domain in the model and it works perfectly, but I try to do it with a datetime field and shows me an error message.

The code I use is

'agenda_id': fields.many2one ('delphos.citamedica.agenda', 'Agenda', required = True, domain = "[('doctor_id', '=', doctor_id), ('date', '> =', ((context_today ()). strftime ('% Y-% m-% d% H:% m:% S'))), ('date_deadline', '<=', ((context_today ()). strftime ('% Y-% m-% d% H:% m:% S')))] "),

The error message says: Uncaught Error: ValueError: No known conversion for% H

That could be my mistake?

Gustavo
on 8/27/13, 12:24 PM

probably there should not be a space between "%" and "H"?

Wided
on 3/31/14, 6:37 AM

Thank you very much for sharing this solution. It has helped me very much.

P.V.Anthony
on 4/23/16, 3:27 AM

How great it is that the documentation says almost nothing about this.

Aron Lorinc
on 6/16/16, 3:21 AM
4

Francesco OpenCode

--Francesco OpenCode--
3608
| 5 7 9
Grottaglie, Italy
--Francesco OpenCode--

Italian Odoo (OpenERP) Modules Developer LINKEDIN: http://www.linkedin.com/in/francescoapruzzese

Francesco OpenCode
On 3/26/13, 7:12 AM

Try this:

[('date', '&gt;=', (context_today() - datetime.timedelta(10)).strftime('%%Y-%%m-%%d') )]

Unfortunately, that doesn't work.

Wided
on 3/26/13, 7:39 AM

If you share the error we can help you. Why this code doesn't work?

Francesco OpenCode
on 3/26/13, 7:57 AM

There's no error, it's a filter I'm creating in a view, when I use it I don't get my lines filtered. This is probably because filters in the views differ from the other filters. Anyway, thanks for your answer.

Wided
on 3/26/13, 8:18 AM

+1 for the format for views

Camptocamp SA
on 4/23/13, 10:36 AM
1
Wided
On 3/26/13, 8:03 AM

The only expression that works is:

[('move_ids.date', '=' , (time.strftime('%Y-%m-%d'))]

I don't know how to integrate delay in it.

Thanks for the update. it works :). For your question you can find in search view for crm.lead examples for delays. Hope this is not too late. Cheers!

Mihai Marius
on 10/21/13, 7:47 PM

Thanks, but I didn't find the example you've mentioned in the crm.lead search view. Can you give the line number, please?

Wided
on 3/31/14, 6:45 AM

Hi, In view "crm.lead.report.select" first 3 or 4 lines are filter buttons which are using domain filters in views for current year, month or last month.

Mihai Marius
on 3/31/14, 7:09 AM

Your Answer

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

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

4 follower(s)

Stats

Asked: 3/26/13, 7:05 AM
Seen: 10811 times
Last updated: 4/13/16, 4:49 AM