Databases
StackOverflow2013
Postsdbo
POHow to find (and maybe extend) the list of available field names for reports in the OpenERP server sourcecode?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to find (and maybe extend) the list of available field names for reports in the OpenERP server sourcecode?
    text
    copied!<p>I am looking for a reliable way to get names of available data fields when creating or extending OpenOffice/LibreOffice report files.</p> <p>I already do know many field names from the existing reports. I also can lookup the field names in the module definitions.</p> <p>For example in the file addons\base\res\partner\partner.py I find a field list for the partner model:</p> <pre><code>class res_partner(osv.osv): _columns = { 'name': fields.char('Name', size=128, required=True, select=True), 'date': fields.date('Date', select=1), 'title': fields.many2one('res.partner.title','Partner Form'), 'parent_id': fields.many2one('res.partner','Parent Partner'), 'child_ids': fields.one2many('res.partner', 'parent_id', 'Partner Ref.'), # many more... } </code></pre> <p>But this is only guessing and it is not complete. I would prefer to know the fields that are really available for any given report, and not guess.</p> <p>There are also reports with data from linked tables, which is also important.</p> <p>For instance if I print an invoice there should be also the delivery address and the billing address available for the report, including the name field of the contact. </p> <p>(It is also possible to use the "OpenERP Report Designer" addon for OpenOffice. You find that solution here: <a href="https://stackoverflow.com/questions/8637013">How to get field lists using the OpenERP Report Designer Addon for OpenOffice / LibreOffice</a> )</p> <p>How can I find out the available fields - and the best would be to also know how to make more of the existing fields available to the reports, for example from linked tables. </p> <p>This would maybe include how to find the function definition that provide the fields. And I guess making more fields avalable would best be done by extending the respective module and rewriting the function that delivers the data to the report.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload