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.