Zum Inhalt springen
Sie müssen registriert sein, um mit der Community zu interagieren.
Alle Beiträge Personen Abzeichen
Stichwörter (Alle anzeigen)
odoo accounting v14 pos v15
Über dieses Forum
Diese Frage wurde gekennzeichnet
pgadminodoo16features
1 Antworten
4555 Ansichten
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
Verwerfen
Avatar
Savya Sachin
Beste Antwort

Hi,

Please try this query,

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

Output:


Thanks

Avatar
Verwerfen
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

Verknüpfte Beiträge Antworten Ansichten Aktivität
DeprecationWarning: The longpolling-port is a deprecated alias to the gevent-port option, please use the latter Gelöst
odoo16features
Avatar
Avatar
Avatar
Avatar
Avatar
5
Sept. 25
24615
How to Add wizard under print button inside the form view.
odoo16features
Avatar
Avatar
Avatar
Avatar
3
Aug. 25
3756
How to add @api.onchange in _get_view() method odoo 16
odoo16features
Avatar
Avatar
1
Mai 25
3660
get all partners which are internal users or portal users odoo16
odoo16features
Avatar
Avatar
1
Apr. 25
4506
How to add decoration color green with bold to a record with a single conditon
odoo16features
Avatar
Avatar
1
Apr. 25
5357