(Tryton 5.0) I’m trying to find all fields I can access in a report, following data/table relations. Do modules and Tryton have documentation about database structure and relations?

An example I don’t find in Administration-Models-Fields: sale.payment_term.name A relation like this one I had to explore trough SQL database tables, making test and error. Where can I find a database relations map?

[image] narcisgarcia: An example I don’t find in Administration-Models-Fields: sale.payment_term.name It is there. In the sale.sale model you can find the field payment_term which has as relation account.invoice.payment_term which has a name field. It will be easier to browse if we showed a…

Okay, i go to Administration-Models-Models and filter model name: sale.sale I double-click the record to open detail and I see a Fields collection, where I find account.invoice.payment_term But: How do I explore its collection with fields like the case “name” ?

[image] narcisgarcia: sale.payment_term.name In model ‘sale.sale’ (database: sale_sale), has a field called “payment_term” which is “Many2One” field from model “account.invoice.payment_term” [test] or you may check on the the table “account_invoice_payment_term”,

Thank you, but: If I search “Model Name”: sale.sale Target model records are not listed: account.invoice.payment_term I’m trying to find a way to find other relations from (as this sale.sale example) any data object through whole available tree. ¿How can I explore or browse to walk from sale.sal…

What field in account_invoice are you looking for ?

[image] bala4901: What field in account_invoice are you looking for ? Everyone. Is there some published documentation about names and relations rules for writing report fields? This all seems a litlle complicated for non Tryton developers, and I want to try to make reports opening database …

[image] narcisgarcia: I want to try to make reports opening database from another database GUI manager. This is another big reason to need a database relations map. I think it is wrong to focus on database level. On tryton we have Function fields which do not exist on database but you can use…

I don’t care if Tryton software computes more calculated fields as an additional layer to database ones: I want to design reports without having to reach developer knowledge level. This can be possible with a fields map with their relations easy to explore: Either through complete documentation or …

Where can I find a database relations map?

Support User

ced (Cédric Krier) February 7, 2020, 12:42pm 2

You can browse models from “Administration>Models”.

How to dump variables and fields in a report

Topic		Replies	Views
How to dump variables and fields in a report User	4	561	February 8, 2020
Tools for AI powered coding? Developer	2	95	May 21, 2026
Addressing Company Invoice Party Name in Report User	3	392	August 2, 2021
List of modules and what they do User	13	4027	May 15, 2020
Adding fields to report.template Developer	8	374	October 5, 2022

Where can I find a database relations map?

Related topics