how to extract portion of data from Jsonb type field?

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

how to extract portion of data from Jsonb type field?

pgadmin odoo16features

1 Antworten

3757 Ansichten

SmithJohn45

i want to extract data from table: product_template field "name" where data is in json format, i want to extract portion of data as below (2nd screenshot) in blue rectangle (without double quotes " ), please help how i can do it?

i am using PgAdmin4, here are 2 screenshots:

regards

Savya Sachin

Beste Antwort

Hi,

Please try this query,

SELECT name ->> 'en_US' AS product_name FROM product_template;

Output:

Thanks

SmithJohn45

Autor

thanks for help... it works fine.
but, as mentioned, i want it without double quotes " ... how to remove it?
regards

Savya Sachin

I have updated the answer, please check

SmithJohn45

Autor

thanks a bunch!!! brillieant !! it saves to write a function. i thought i have to write a function and use replace function to eliminate double quotes.
regards

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 Add wizard under print button inside the form view. odoo16features	3 Aug. 25	2693
How to add @api.onchange in _get_view() method odoo 16 odoo16features	1 Mai 25	2683
get all partners which are internal users or portal users odoo16 odoo16features	1 Apr. 25	3673
How to add decoration color green with bold to a record with a single conditon odoo16features	1 Apr. 25	4525
Favicons not working with Bing odoo16features	1 Apr. 25	1987

Diese Frage wurde gekennzeichnet

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