علامات التصنيف (عرض الكل)

search sales order by customer's phone number & email

2 الردود

11842 أدوات العرض

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

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 ;-)

أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!

تسجيل

المنشورات ذات الصلة	الردود	أدوات العرض
Uncaught TypeError: Cannot read property '1' of undefined تم الحل customer sale	12 مايو 21	277679
(v7) customer search customer search	1 مارس 15	4588
product variant product customer sale variant	3 فبراير 24	2418
Is there a way I can duplicate the search bar in sale.order -> products -> search more? sale search attribut odoo8.0	0 يونيو 16	4664
How to filter related search suggestions? filter customer search contact	2 مارس 15	7296