ORM Query Search

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Akuntansi
Inventaris
PoS
Project
MRP

All apps

Semua Post Orang Lencana-Lencana

Label (Lihat semua)

odoo accounting v14 pos v15

Mengenai forum ini

Help

ORM Query Search

orm query

7 Replies

14906 Tampilan

Usman Farzand

i need to filter product which color is red & size is small

self.env['product.template'].search([('name', '=', 'Product A"]),(attribuet_value,'=',''),], limit=1)

how i can search it ... any help

Sehrish

You have to learn basic customization in odoo: https://github.com/sehrishnaz/learnopenerp/wiki

Gokulakrishnan Murugesan

Jawaban Terbai

Hi Usman,

Try this code,

products = self.env['product.template'].search([('attribute_line_ids.attribute_id', '=', "Color Name"),('attribute_line_ids.value_ids', 'in', "Small")], limit=1)

If you know the ID of Color and Size, You can use it directly.

Thanks

Avinash Nk

Hi Usman,

Try this code.

products = self.env['product.product'].search([('name', '=', 'Product A'),
                                               ('attribute_value_ids.name', '=', 'red'),
                                               ('attribute_value_ids.name', '=', 'small')])

Thanks

Hilar Andikkadavath

searching with the name? Please Update your answer.

Avinash Nk

Hi Hilar

What is wrong in the search for the name?

Hilar Andikkadavath

What if the name is get changed? Do you update the code in live server with the name? The name field will not be a unique constraint, however. Think

Avinash Nk

Your point is good. and it is not a piece of new knowledge for me. We can't predefine what the end-users needs.

Right?

Hilar Andikkadavath

Good to hear from you. We should able to predefine the end-users needs anyway. That is the role of a coder.

Avinash Nk

Thank you for the valuable advice. Have a nice day

Menikmati diskusi? Jangan hanya membaca, ikuti!

Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!

Daftar

Post Terkait	Replies	Tampilan
How can I display data from database in form view query	0 Sep 23	6220
Insert query in odoo 13 Diselesaikan query	1 Jul 20	4982
How can i write update query in a function? Diselesaikan query	3 Jan 20	12673
ORM Relationship in Odoo 12 orm	0 Sep 19	98
ParseError: "duplicate key value violates unique constraint "res_groups_name_uniq"? query	0 Des 23	8069

Pertanyaan ini telah diberikan tanda

Menikmati diskusi? Jangan hanya membaca, ikuti!