تخطي للذهاب إلى المحتوى
القائمة
لقد تم الإبلاغ عن هذا السؤال
2 الردود
10475 أدوات العرض

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
مايو 21
273366
1
مارس 15
3618
3
فبراير 24
1243
0
يونيو 16
3304
2
مارس 15
6104