Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hello,
i am a newbie on creating my own reports, so i've just take a look at "sale.report" or "purchase.report" models as reference.
I just saw, on the select query, something like:
SELECT min(l.id) as id,
s.date_order as date_order,
p.product_tmpl_id,
t.categ_id as category_id
....
what is the meaning "l", "s", "p" and "t" at the beggining of each value?
They are aliases for the table names used in the from clause. Aliases are typically used so that you can avoid typing the full table name multiple times. Also, aliases are useful when you have to use the same table in different contexts within your query.
where are aliases defined?
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
