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

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

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

Avatar

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

by
feihu.zhang
- 13/11/2024 10:23:03

Hi Graeme

 

I apologize for the incorrect domain I provided in the email.

 

The method you suggested using blue%desk can indeed solve my problem.

However, for end users without development experience, understanding and remembering this method might be challenging, especially if they do not use it frequently.

 

I look forward to any other potential solutions you or other contributors might offer.

 

Thank you once again!

 

Best regards,    

 

 

 

发件人: Graeme Gellatly <notifications@odoo-community.org>
发送时间: 2024-11-13 16:44
收件人: Contributors <contributors@odoo-community.org>
主题: Re: Assistance Needed: Searching for Specific Products in Sales Orders (Odoo CE 17.0+)

 

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