İçereği Atla
Menü
Bu soru işaretlendi
2 Cevaplar
10104 Görünümler

hello

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

how can i achieve this??

skype id

shashank_leosys

Avatar
Vazgeç
En İyi Yanıt

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.

Avatar
Vazgeç
Üretici

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.

En İyi Yanıt

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)]"/>
Avatar
Vazgeç
Üretici

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

Üretici

lolzzzz ;-)

İlgili Gönderiler Cevaplar Görünümler Aktivite
12
May 21
272336
1
Mar 15
3353
3
Şub 24
924
0
Haz 16
2916
2
Mar 15
5763