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
databasesearchsqlodoo
1 Odpovědět
1556 Zobrazení
Avatar
Vikas Jadav

following is  a table of product_attribute and i want to search record of attribute using name like 
self.env.cr.execute("SELECT id FROM product_attribute WHERE name='Legs'")

it raises a error 
psycopg2.errors.InvalidTextRepresentation: invalid input syntax for type json

LINE 1: SELECT id FROM product_attribute WHERE name='Legs'



Any solution for this except using search() ? 

Avatar
Zrušit
Avatar
Adnan Dahodwala
Nejlepší odpověď

First off, if there is any chance avoid using the string to search any records, but you can achieve your expected output if you modify your query in this way using ILIKE :

SELECT id FROM product_attribute WHERE name ILIKE '%Legs%'

Avatar
Zrušit
Vikas Jadav
Autor

Thanks for the reply,
I understand that using string to find a record is not a good practice and i am doing it for custom script to create a records from files so i do not have another option.
I think with there is risk while using ilike, if there is similar string or it is substring of other string then it will give me a wrong id.

Related Posts Odpovědi Zobrazení Aktivita
clean purchase history
database odoo
Avatar
Avatar
1
bře 24
1783
How can I recover ownership? Vyřešeno
database odoo
Avatar
Avatar
1
úno 23
2079
Odoo database failed Vyřešeno
database odoo
Avatar
Avatar
1
pro 22
11662
Edit Company data Powered by Odoo Vyřešeno
database odoo
Avatar
Avatar
6
čvn 15
7938
many2one field search for by multiple criteria (name, phone number, etc)?
many2one search odoo
Avatar
Avatar
Avatar
2
úno 25
8551