[19.0] bi_sql_editor HTML content renders as raw text (not formatted) in Odoo 19 List views

Maintainers usually reply within 1 day

Assessment

Research direction

Description

Module

bi_sql_editor

Describe the bug

HTML content in CHAR fields correctly displays with the HTML widget in Odoo 16 but not Odoo 17, Odoo 18 or Odoo 19. This is because in Odoo 17 field widgets are resolved through the fields registry and there's now stricter matching between a widget and the declared field type. When the widget/type pairing doesn't line up the way the registry expects, the List view falls back to the generic/default renderer for the field's actual ttype (char), which just prints the raw string — tags and all.

To Reproduce

Odoo 17, Odoo 18, Odoo 19

Steps to reproduce the behavior:

1. create a SQL view containing a field with HTML content
2. create and open the UI in List View
3. observe the raw rendering of the content

Expected behavior
The content should render as other html fields do with the html widget

Solution
Support the html field type

Add "html" as an option to _TTYPE_SELECTION

https://github.com/OCA/reporting-engine/blob/19.0/bi_sql_editor/models/bi_sql_view_field.py#L16

Getting set up

First steps

1. Read the whole issue, then the project's contributing guide.
2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
3. Fork the repository and make your change on a branch.
4. Open a pull request that references the issue number.

More from OCA/reporting-engine

• Migration to version 20.0

  Possibly taken A pull request linked to this issue is open or already merged. Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  help wanted no stale work in progress

  Difficulty 2/5 1-3 hours Newbie friendliness 66/100

  OCA/reporting-engine#1206 · 3 comments · Opened Oct 5, 2026

  Maintainers usually reply within 1 day

• Properties Handling When Exporting

  Possibly taken A pull request linked to this issue is open or already merged. Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  bug

  Difficulty 2/5 Under an hour Newbie friendliness 85/100

  OCA/reporting-engine#1190 · Opened Aug 22, 2026

  Maintainers usually reply within 1 day

• [20.0] Proposal to merge report_py3o_fusion_server in report_py3o

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement

  Difficulty 3/5 1-2 days Newbie friendliness 65/100

  OCA/reporting-engine#1197 · 2 comments · Opened Sep 12, 2026

  Maintainers usually reply within 1 day

• [BUG]- Odoo version 19 -OpenUpgrade module - psycopg2.errors.DatatypeMismatch: argument of AND must be type boolean, not type character varying

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  bug stale

  Difficulty 4/5 3-5 days Newbie friendliness 22/100

  OCA/reporting-engine#1136 · 2 comments · Opened Feb 23, 2026

  Maintainers usually reply within 1 day

• Migration to version 19.0

  Possibly taken A pull request linked to this issue is open or already merged. Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  help wanted no stale work in progress

  Difficulty 4/5 3-5 days Newbie friendliness 30/100

  OCA/reporting-engine#1070 · 12 comments · Opened Sep 29, 2025

  Maintainers usually reply within 1 day

All issues in OCA/reporting-engine

Similar issues

• fix(chat): a bot file link still fails when attach_file renamed the file, so the delivered copy is never found

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 2/5 1-3 hours Newbie friendliness 62/100

  milind-soni/OpenMausBot#5829 · Opened Nov 14, 2026

  Maintainers usually reply within 1 day

• fluxnova: attributes in DMN are ignored

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 2/5 1-3 hours Newbie friendliness 80/100

  finos/fluxnova-bpm-platform#387 · Opened Nov 14, 2026

  Maintainers usually reply within 4 days

• Remove the Studies tab from the Admin section

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 2/5 1-3 hours Newbie friendliness 62/100

  OHDSI/Data2Evidence#3693 · Opened Nov 14, 2026

  Maintainers usually reply within 3 days

• [Bug Report]: launcher 的 Playwright 自检在 playwright >= 1.63 上恒报 skipped（compute_driver_executable 已返回 tuple）

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 2/5 1-3 hours Newbie friendliness 72/100

  Project-N-E-K-O/N.E.K.O#3725 · Opened Nov 14, 2026

  Maintainers usually reply within 1 day

• backend: plugins: isSubdirectory rejects hidden (dot-prefixed) plugin directories

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 2/5 1-3 hours Newbie friendliness 82/100

  kubernetes-sigs/headlamp#8408 · Opened Nov 14, 2026

  Maintainers usually reply within 1 day

More Backend & API Design issues