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:

客戶關係
e-Commerce
會計
庫存
PoS
Project
MRP

All apps

所有帖文人獎章

標籤（查看所有）

odoo accounting v14 pos v15

關於此討論區

支援

how to extract portion of data from Jsonb type field?

pgadmin odoo16features

1 回覆

3611 瀏覽次數

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

最佳答案

Hi,

Please try this query,

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

Output:

Thanks

SmithJohn45

作者

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

作者

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

喜歡這則討論？不要只閱讀，加入發表意見吧！

今天就建立帳戶，享受獨家功能，與我們精彩的社群互動！

註冊

相關帖文	回覆	瀏覽次數
How to add @api.onchange in _get_view() method odoo 16 odoo16features	1 5月 25	2433
get all partners which are internal users or portal users odoo16 odoo16features	1 4月 25	3451
How to add decoration color green with bold to a record with a single conditon odoo16features	1 4月 25	4271
Favicons not working with Bing odoo16features	1 4月 25	1754
Auto adjust the width of Tree view fields Odoo 16 odoo16features	4 3月 25	6859

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！