Relational fields
Navigate through Odoo's relational structure to build cross-model charts and indicators.
Why relational fields matter
A chart built on a single table is great. A chart built on cross-model data is even better. In O'Dashboard, you can navigate through Odoo's relational structure as deep as you need — across any model, in any direction.
Relation types in Odoo
When navigating through fields, you'll encounter different relation types:
- Many2one — links to a single record in another table (e.g. a product's category)
- One2many — links to multiple records in another table (e.g. a sale order's lines)
- Many2many — links multiple records to multiple records (e.g. tags on a record)
Example: sales by product category
Let's say you want to see total sales broken down by product category. To get there, you'll need to cross several models — from sales orders, through products, all the way up to product categories.
Start by selecting the Sale Order table and adding the Total field as a column. Then set up the group by by navigating through the relational chain:
- Sale Order Lines — a one-to-many relation
- Product Variants — a many-to-one relation
- Product Template — a many-to-one relation
- Product Categories — a many-to-one relation
- Select the Name field, which represents the category name
No depth limit
This navigation system works the same way across columns, filters, and group by. You can chain as many relational jumps as needed — O'Dashboard handles the complexity for you.
Hit Run — and there it is. Total sales, grouped by product category. Across four relational jumps, in just a few clicks.
Cross-model, made simple
No SQL required. Navigate Odoo's entire relational structure visually and build powerful cross-model charts in seconds.