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

hello

i want to search sales order records by customer's phone number & emial id

how can i achieve this??

skype id

shashank_leosys

아바타
취소
베스트 답변

There is no field of Customer Phone in Sale Order. So you cannot search for that.

You can create related field of Customer Phone.

'customer_phone': fields.related('partner_id', 'phone', type='char'),

Now add this field in search view of Sale Order.

아바타
취소
작성자

thanks sudhir

bythe way i tried an alternate way to achieve this

i put this code in serach view

<field name="name" string="phone number" filter_domain="[('partner_order_id.phone','ilike',self)]"/>

<field name="name" string="email" filter_domain="[('partner_order_id.email','ilike',self)]"/>

its working f9

but your solution much easier and compact once again thanks

are you on skype?? can i have ur skype id?

Sorry I don't have account of skkype. You can contact me on linkedin.

베스트 답변

Insert this line in sale order search:

<field name="name" string="email" filter_domain="['|', ('partner_order_id.email','ilike',self), ('partner_order_id.phone','ilike',self)]"/>
아바타
취소
작성자

thanks for response but i have done the same thing ;-)

Then my answer is correct for you. I don't know what you do to the other side of the world! :D

작성자

lolzzzz ;-)

관련 게시물 답글 화면 활동
12
5월 21
273337
1
3월 15
3604
3
2월 24
1232
0
6월 16
3298
2
3월 15
6095