1. Mailing Lists
  2. Contributors
  3. Assistance Needed: Searching for Specific Products in Sales Orders (Odoo CE 17.0+)

Contributors mailing list archives

contributors@odoo-community.org

Browse archives

Real time GPS tracker

Click on line in tree view that's embedded in form to change context value for another field on the form

Avatar

Assistance Needed: Searching for Specific Products in Sales Orders (Odoo CE 17.0+)

by
feihu.zhang
- 13/11/2024 07:00:42

Dear Contributors

 

       I have a question regarding the search for one2many fields and would like to seek assistance from the community.

      

       Odoo Version：Community 17.0+

      

       I created some products:：

l   Blue xxxsome_elsexx T-shirt

l   Blue xxxsome_elsexx Desk

l   White xxxsome_elsexx T-shirt

l   White xxxsome_elsexx Desk

 

Then, I randomly created some sales orders using these products. Now, if I want to search for the product "Blue xxxsome_elsexx Desk" within sales orders using this domain:

[("order_line.product_id.name", "ilike", "blue"),(("order_line.product_id.name", "ilike", "desk"))]

 

I expect to get sales orders only containing the productBlue xxxsome_elsexx Desk，

However, the search results return sales orders containing Blue xxxsome_elsexx T-shirt and White xxxsome_elsexx Desk，but not those containing Blue xxxsome_elsexx Desk；

 

I am not sure if I have expressed this clearly. You can test the scenario with the sales orders I created in the runbot instance, and there are a few images to help with understanding.

Testing environment on runbot: https://70500325-17-0-all.runbot143.odoo.com/web?debug=1#action=988&model=sale.order&view_type=list&cids=1&menu_id=660

 

 

 

 

       Thank you for your assistance.

Best regards,

 

 

 

feihu.zhang@live.com

Follow-Ups