콘텐츠로 건너뛰기
메뉴
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
신고된 질문입니다
7 답글
15195 화면

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

아바타
취소

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

베스트 답변

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

아바타
취소
베스트 답변

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

아바타
취소

searching with the name? Please Update your answer.

Hi Hilar

What is wrong in the search for the name?

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

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?

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

Thank you for the valuable advice. Have a nice day

관련 게시물 답글 화면 활동
0
9월 23
6590
1
7월 20
5320
3
1월 20
13135
0
9월 19
98
0
12월 23
8472