Odoo Help


dashboard report based on moving date

Jeff Moseler
on 4/4/13, 2:02 PM 1,728 views

I would like to put a report on my dashboard of all the employee contracts that are ending in the next 60 days. How can I enter a formula or a trigger or something to update the report each day?

I wrote an SQL for it in pgAdmin, but I'm unsure how to get OpenERP to run the query and add it to the dashboard.


Yannick Vaucher - Camptocamp

--Yannick Vaucher - Camptocamp--

| 5 7 9
Lausanne, Switzerland
--Yannick Vaucher - Camptocamp--
Yannick Vaucher - Camptocamp
On 4/30/13, 10:24 AM

You should refer to CRM dashboard in crm module to know how to create your reporting data using a SQL request in a custom module.

Then you will be able to add a domain like this in your XML file:

domain="[('<date_field>','&lt;=', ((context_today()+datetime.timedelta(days=60)).strftime('%%Y-%%m-%%d')))]"

Or you can create a filter like this in your list view to try to create the one you will add to your dashboard.

  string="Contracts ending in next 60 days"
  domain="[('<date_field>','&lt;=', ((context_today()+datetime.timedelta(days=60)).strftime('%%Y-%%m-%%d')))]"/>

About This Community

This platform 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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 4/4/13, 2:02 PM
Seen: 1728 times
Last updated: 3/16/15, 8:10 AM