Skip to Content
  2. Mailing Lists
  3. Contributors
  4. Re: 回复: Assistance Needed: Searching for Specific Products in Sales Orders (Odoo CE 17.0+)

Archives

Contributors

回复: 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+)

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

> Further, is it possible to use multiple layered search criteria in the

> search view to make the operation more user-friendly? For example:

I'm not aware of anything like that in Odoo standard, but
https://github.com/OCA/web/tree/16.0/web_advanced_search
used to be able to do something similar.

Would make a lot of sense to implement your case in a yet to be done migration 
of this module to v17, things like that have a habit of appearing in 
subsequent versions of Odoo.


-- 
Your partner for the hard Odoo problems
https://hunki-enterprises.com
by Holger Brunn - 10:31 - 13 Nov 2024

1 attachments 1 attachments

signature.asc

Reference

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

    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

    by feihu.zhang - 07:01 - 13 Nov 2024

    3 attachments 3 attachments

    image003.png
    image002.png
    image001.png