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
Бухгалтерия
Склад
PoS
Project
MRP

All apps

All Posts Люди Значки

Теги (View all)

odoo accounting v14 pos v15

Об этом форуме

Помощь

Not getting record in qweb report.

record qweb-report QWeb

1 Ответить

174 Представления

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

Автор

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

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Регистрация

Related Posts	Ответы	Просмотры
How to create a report with a custom chart and use the chart in the QWEB report? qweb-report	0 янв. 24	1802
Curious to know how the same variable show different values under the same loop in Qweb. qweb-report	0 янв. 24	1502
Error al imprimir un Qweb (espacio en blanco al principio de la hoja) qweb-report	0 февр. 22	2625
[v8] How to create qweb pdf report correctly using a custom module qweb-report	2 сент. 16	10405
In Report module when we create own Footer giving error record	2 июн. 16	3542

Этот вопрос был отмечен

Enjoying the discussion? Don't just read, join in!