I have created model in Odoo where I have the data, and I want to show that data in a PDF report format. below is the model. Image [1] below is the report template Image [2] while accessing I'm getting the record. Image [3] but while printing the field value I'm getting below error. MissingError: Record does not exist or has been deleted. but I'm getting record here. if not also it should have go to else but it's giving error. Traceback (most recent call last): File " ",

Hi, Try with the following code, Dispatch Checklist – Picking: Customer: Dispatch Date: Hope it h

Not getting record in qweb report.

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Buchhaltung
Lager
PoS
Project
MRP

All apps

Alle Beiträge Personen Abzeichen

Stichwörter (Alle anzeigen)

odoo accounting v14 pos v15

Über dieses Forum

Hilfe

Not getting record in qweb report.

record qweb-report QWeb

1 Antworten

160 Ansichten

Vikas Maharana

I have created model in Odoo where I have the data, and I want to show that data in a PDF report format.

below is the model.

below is the report template

while accessing <t t-esc="o"/> I'm getting the record.

but while printing the field value I'm getting below error.
MissingError: Record does not exist or has been deleted.

but I'm getting record here. if not also it should have go to else but it's giving error.

Traceback (most recent call last):
  File "<3312>", line 128, in template_3312
  File "<3312>", line 109, in template_3312_content
  File "<3312>", line 17, in template_3312_t_call_1
  File "D:\odoo18\odoo\odoo\fields.py", line 3059, in __get__
    return super().__get__(records, owner)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\odoo18\odoo\odoo\fields.py", line 1272, in __get__
    raise MissingError("\n".join([
odoo.exceptions.MissingError: Record does not exist or has been deleted.
(Record: dispatch.checklist(51570,), User: 2)

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "D:\odoo18\odoo\addons\web\controllers\report.py", line 120, in report_download
    response = self.report_routes(reportname, docids=docids, converter=converter, context=context)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\odoo18\odoo\odoo\http.py", line 754, in route_wrapper
    result = endpoint(self, *args, **params_ok)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\odoo18\odoo\addons\web\controllers\report.py", line 42, in report_routes
    pdf = report.with_context(context)._render_qweb_pdf(reportname, docids, data=data)[0]
          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\odoo18\odoo\odoo\addons\base\models\ir_actions_report.py", line 1017, in _render_qweb_pdf
    collected_streams, report_type = self._pre_render_qweb_pdf(report_ref, res_ids=res_ids, data=data)
                                     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\odoo18\odoo\addons\account\models\ir_actions_report.py", line 75, in _pre_render_qweb_pdf
    return super()._pre_render_qweb_pdf(report_ref, res_ids=res_ids, data=data)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\odoo18\odoo\odoo\addons\base\models\ir_actions_report.py", line 1008, in _pre_render_qweb_pdf
    return self._render_qweb_pdf_prepare_streams(report_ref, data, res_ids=res_ids), 'pdf'
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\odoo18\odoo\addons\sale_pdf_quote_builder\models\ir_actions_report.py", line 17, in _render_qweb_pdf_prepare_streams
    result = super()._render_qweb_pdf_prepare_streams(report_ref, data, res_ids=res_ids)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "d:\odoo18\enterprise\account_followup\models\ir_actions_report.py", line 12, in _render_qweb_pdf_prepare_streams
    res = super()._render_qweb_pdf_prepare_streams(report_ref, data, res_ids)
          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\odoo18\odoo\addons\purchase\models\ir_actions_report.py", line 12, in _render_qweb_pdf_prepare_streams
    collected_streams = super()._render_qweb_pdf_prepare_streams(report_ref, data, res_ids=res_ids)
                        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\odoo18\odoo\addons\account_edi_ubl_cii\models\ir_actions_report.py", line 11, in _render_qweb_pdf_prepare_streams
    collected_streams = super()._render_qweb_pdf_prepare_streams(report_ref, data, res_ids)
                        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\odoo18\odoo\addons\account_edi\models\ir_actions_report.py", line 14, in _render_qweb_pdf_prepare_streams
    collected_streams = super()._render_qweb_pdf_prepare_streams(report_ref, data, res_ids=res_ids)
                        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\odoo18\odoo\addons\account\models\ir_actions_report.py", line 22, in _render_qweb_pdf_prepare_streams
    return super()._render_qweb_pdf_prepare_streams(report_ref, data, res_ids=res_ids)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\odoo18\odoo\odoo\addons\base\models\ir_actions_report.py", line 856, in _render_qweb_pdf_prepare_streams
    html = self.with_context(**additional_context)._render_qweb_html(report_ref, all_res_ids_wo_stream, data=data)[0]
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "d:\odoo18\enterprise\web_studio\models\ir_actions_report.py", line 24, in _render_qweb_html
    return super(IrActionsReport, self)._render_qweb_html(report_ref, docids, data)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\odoo18\odoo\odoo\addons\base\models\ir_actions_report.py", line 1096, in _render_qweb_html
    return self._render_template(report.report_name, data), 'html'
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\odoo18\odoo\odoo\addons\base\models\ir_actions_report.py", line 772, in _render_template
    return view_obj._render_template(template, values).encode()
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "d:\odoo18\enterprise\web_studio\models\ir_ui_view.py", line 1332, in _render_template
    return super(View, self)._render_template(template, values)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\odoo18\odoo\addons\website\models\ir_ui_view.py", line 453, in _render_template
    return super()._render_template(template, values=values)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\odoo18\odoo\odoo\addons\base\models\ir_ui_view.py", line 2199, in _render_template
    return self.env['ir.qweb']._render(template, values)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\odoo18\odoo\odoo\tools\profiler.py", line 313, in _tracked_method_render
    return method_render(self, template, values, **options)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "D:\odoo18\odoo\odoo\addons\base\models\ir_qweb.py", line 606, in _render
    result = ''.join(rendering)
             ^^^^^^^^^^^^^^^^^^
  File "<3312>", line 136, in template_3312
odoo.addons.base.models.ir_qweb.QWebException: Error while render the template
MissingError: Record does not exist or has been deleted.
(Record: dispatch.checklist(51570,), User: 2)
Template: abcl_sale.dispatch_checklist_report_template
Path: /t/t[2]/t/div/div[2]/h3/t[2]/span
Node: <span t-field="o.picking_id"/>

The above server error caused the following client error:
RPC_ERROR: Odoo Server Error
    RPC_ERROR
        at makeErrorFromResponse (http://localhost:8069/web/assets/debug/web.assets_web.js:29862:19)
        at decoder.onload (http://localhost:8069/web/assets/debug/web.assets_web.js:29750:25)

what I'm doing wrong?
how to get currect record?

Please help on this.

Cybrosys Techno Solutions Pvt.Ltd

Hi,

Try with the following code,

Dispatch Checklist – <t t-esc="o.name or ''"/>

</h3>

<p>

Picking: <t t-esc="o.picking_id.name or 'No Picking ID'"/>

</p>

<p>

Customer: <t t-esc="o.customer_id.name or 'N/A'"/>

</p>

<p>

Dispatch Date: <t t-esc="o.dispatch_date or ''"/>

</p>

</div>

</t>

Hope it helps

Vikas Maharana

Autor

Even if I try sudo() I'm getting same error.
can you tell me the possible reasons to identify the issue

Diskutieren Sie gerne? Treten Sie bei, statt nur zu lesen!

Erstellen Sie heute ein Konto, um exklusive Funktionen zu nutzen und mit unserer tollen Community zu interagieren!

Registrieren

Verknüpfte Beiträge	Antworten	Ansichten
How to create a report with a custom chart and use the chart in the QWEB report? qweb-report	0 Jan. 24	1798
Curious to know how the same variable show different values under the same loop in Qweb. qweb-report	0 Jan. 24	1499
Error al imprimir un Qweb (espacio en blanco al principio de la hoja) qweb-report	0 Feb. 22	2625
[v8] How to create qweb pdf report correctly using a custom module qweb-report	2 Sept. 16	10393
In Report module when we create own Footer giving error record	2 Juni 16	3531

Diese Frage wurde gekennzeichnet

Diskutieren Sie gerne? Treten Sie bei, statt nur zu lesen!