Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
pgadminodoo16features
1 Odgovori
3632 Prikazi
Avatar
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


 

Avatar
Opusti
Avatar
Savya Sachin
Best Answer

Hi,

Please try this query,

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

Output:


Thanks

Avatar
Opusti
SmithJohn45
Avtor

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
Avtor

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

Related Posts Odgovori Prikazi Aktivnost
How to add @api.onchange in _get_view() method odoo 16
odoo16features
Avatar
Avatar
1
maj 25
2448
get all partners which are internal users or portal users odoo16
odoo16features
Avatar
Avatar
1
apr. 25
3467
How to add decoration color green with bold to a record with a single conditon
odoo16features
Avatar
Avatar
1
apr. 25
4296
Favicons not working with Bing
odoo16features
Avatar
Avatar
1
apr. 25
1778
Auto adjust the width of Tree view fields Odoo 16
odoo16features
Avatar
Avatar
Avatar
Avatar
Avatar
4
mar. 25
6884