Ir al contenido
Esta pregunta ha sido marcada
ormquery
7 Respuestas
16781 Vistas
Avatar
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

Avatar
Descartar
Sehrish

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

Avatar
Gokulakrishnan Murugesan
Mejor respuesta

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

Avatar
Descartar
Avatar
Avinash Nk
Mejor respuesta

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

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

Publicaciones relacionadas Respuestas Vistas Actividad
ORM search based on jsonb field
orm query v18
Avatar
Avatar
2
abr 26
599
How can I display data from database in form view
query
Avatar
0
sept 23
8256
Insert query in odoo 13 Resuelto
query
Avatar
Avatar
1
jul 20
6667
How can i write update query in a function? Resuelto
query
Avatar
Avatar
Avatar
Avatar
3
ene 20
14827
ORM Relationship in Odoo 12
orm
Avatar
0
sept 19
98