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

Contributors mailing list archives

contributors@odoo-community.org

Browse archives

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

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

Avatar

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

by
MoaHub, Graeme Gellatly
- 13/11/2024 09:39:06
Maybe the weird brackets. In any case the easiest domain is "ilike" ,"blue%desk". But you can search blue%desk straight from the search bar in UI. No need to write domains.

On Wed, Nov 13, 2024 at 7:02 PM 张 飞虎 <notifications@odoo-community.org> wrote:

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

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

Reference