Overslaan naar inhoud
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Alle posts Personen Badges
Labels (Bekijk alle)
odoo accounting v14 pos v15
Over dit forum
Deze vraag is gerapporteerd
pgadminodoo16features
1 Beantwoorden
3933 Weergaven
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
Annuleer
Avatar
Savya Sachin
Beste antwoord

Hi,

Please try this query,

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

Output:


Thanks

Avatar
Annuleer
SmithJohn45
Auteur

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
Auteur

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

Gerelateerde posts Antwoorden Weergaven Activiteit
DeprecationWarning: The longpolling-port is a deprecated alias to the gevent-port option, please use the latter Opgelost
odoo16features
Avatar
Avatar
Avatar
Avatar
Avatar
5
sep. 25
21081
How to Add wizard under print button inside the form view.
odoo16features
Avatar
Avatar
Avatar
Avatar
3
aug. 25
3027
How to add @api.onchange in _get_view() method odoo 16
odoo16features
Avatar
Avatar
1
mei 25
2915
get all partners which are internal users or portal users odoo16
odoo16features
Avatar
Avatar
1
apr. 25
3876
How to add decoration color green with bold to a record with a single conditon
odoo16features
Avatar
Avatar
1
apr. 25
4743