Přejít na obsah
You need to be registered to interact with the community.
All Posts Lidé Odznaky
Štítky (View all)
odoo accounting v14 pos v15
O tomto fóru
This question has been flagged
pgadminodoo16features
1 Odpovědět
3762 Zobrazení
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
Zrušit
Avatar
Savya Sachin
Nejlepší odpověď

Hi,

Please try this query,

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

Output:


Thanks

Avatar
Zrušit
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

Related Posts Odpovědi Zobrazení Aktivita
How to Add wizard under print button inside the form view.
odoo16features
Avatar
Avatar
Avatar
Avatar
3
srp 25
2720
How to add @api.onchange in _get_view() method odoo 16
odoo16features
Avatar
Avatar
1
kvě 25
2687
get all partners which are internal users or portal users odoo16
odoo16features
Avatar
Avatar
1
dub 25
3674
How to add decoration color green with bold to a record with a single conditon
odoo16features
Avatar
Avatar
1
dub 25
4527
Favicons not working with Bing
odoo16features
Avatar
Avatar
1
dub 25
1988