For searching purchase orders, normally we search by product other than PO header information such as supplier, even though there is product field (related) available on the purchase order header table, it seems this field only linked to the first item of the PO, so it is not useful for searching PO by product.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Comptabilité
- Inventaire
- PoS
- Projet
- MRP
Cette question a été signalée
6
Réponses
25322
Vues
Per testing, I found the following simple solution: adding following line into relevant search view : purchase.order.list.select
<filter name="order_line" string="product name" domain="[('order_line.product_id.name','ilike',self)]"/>
the background logic for the above simple solution is that system take the searching criteria from search view as a domain, per evaluating the domain, ORM returned result list accordingly, in essence, due to the Model relationship, ORM can evaluate doamain on related models( one2many, many2many), so the above mentioned solution can be applied to other business objects, also tested case is searching issues by the associated message content which is very common requirement when dealing with issue tracking.
Great !!
It works if you change 'filter' to 'field'.
<field name="order_line" string="product name" domain="[('order_line.product_id.name','ilike',self)]"/>
<field name="order_line" string="product name" filter_domain="[('order_line.product_id.name','ilike',self)]"/>
Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !
Créez un compte dès aujourd'hui pour profiter de fonctionnalités exclusives et échanger avec notre formidable communauté !
S'inscrire| Publications associées | Réponses | Vues | Activité | |
|---|---|---|---|---|
|
1
juil. 25
|
1452 | ||
|
Search a message
Résolu
|
|
1
févr. 25
|
1816 | |
|
0
sept. 23
|
2720 | ||
|
2
juin 23
|
4829 | ||
|
2
mai 23
|
3734 |
for search project issue by message subject and body, add the following line to search view Project Issue Tracker Search <field name="message_ids" string="message_content" filter_domain="['|',('message_ids.subject','ilike',self),('message_ids.body','ilike',self)]"/>