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
Akuntansi
Inventaris
PoS
Project
MRP

All apps

Semua Post Orang Lencana-Lencana

Label (Lihat semua)

odoo accounting v14 pos v15

Mengenai forum ini

Help

how to extract portion of data from Jsonb type field?

pgadmin odoo16features

1 Balas

3641 Tampilan

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

Jawaban Terbai

Hi,

Please try this query,

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

Output:

Thanks

SmithJohn45

Penulis

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

Penulis

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

Menikmati diskusi? Jangan hanya membaca, ikuti!

Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!

Daftar

Post Terkait	Replies	Tampilan
How to add @api.onchange in _get_view() method odoo 16 odoo16features	1 Mei 25	2460
get all partners which are internal users or portal users odoo16 odoo16features	1 Apr 25	3478
How to add decoration color green with bold to a record with a single conditon odoo16features	1 Apr 25	4307
Favicons not working with Bing odoo16features	1 Apr 25	1784
Auto adjust the width of Tree view fields Odoo 16 odoo16features	4 Mar 25	6895

Pertanyaan ini telah diberikan tanda

Menikmati diskusi? Jangan hanya membaca, ikuti!