Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
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() ?
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%'
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.
Tạo tài khoản ngay hôm nay để tận hưởng các tính năng độc đáo và tham gia cộng đồng tuyệt vời của chúng tôi!
Đăng ký| Bài viết liên quan | Trả lời | Lượt xem | Hoạt động | |
|---|---|---|---|---|
|
1
thg 3 24
|
1779 | ||
|
How can I recover ownership?
Đã xử lý
|
|
1
thg 2 23
|
2067 | |
|
Odoo database failed
Đã xử lý
|
|
1
thg 12 22
|
11657 | |
|
Edit Company data Powered by Odoo
Đã xử lý
|
|
6
thg 6 15
|
7931 | |
|
2
thg 2 25
|
8550 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
