Add one2many fields in eQ ReportDesigner
- Francisca Hohlberg Rodriguez (Unlicensed)
A possible way to add one2many fields to the reports is by creating a new auxiliary table defined with a SQL query. For example, if you want to add the Project Tasks Types to a table that contains a list of all the Project Tasks, you can create a new auxiliary table called 'project_tasks_and_types' defined by the following SQL query:
SELECT task.id, task.name, task.effective_hours, task.planned_hours, type.name as type_name
FROM project_task as task
LEFT JOIN project_task_type as type on task.id = type.rel_id