Contributors

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

  Sure, I've tried the user training search method and no obstacles, it's amazing!

   

   

   

  feihu zhang

  feihu.zhang@live.com

   

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

   

  % acts like * in search is all the guidance most users need. In my experience that is far simpler than explaining domains and comes in far more useful for them in other ways, esp contacts and m2o dropdowns.

   

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

  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

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

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

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

  ---

  by feihu.zhang - 10:51 - 13 Nov 2024

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

  % acts like * in search is all the guidance most users need. In my experience that is far simpler than explaining domains and comes in far more useful for them in other ways, esp contacts and m2o dropdowns.

  
  

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

  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

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

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

  ---

  by Graeme Gellatly - 10:41 - 13 Nov 2024

• 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

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

  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

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

  ---

  by feihu.zhang - 10:26 - 13 Nov 2024

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

  Hi Holger

   

  Thank you very much for your response; it was of great help to me.

   

  Further, is it possible to use multiple layered search criteria in the search view to make the operation more user-friendly?

  For example: 

  The user first searches for products containing "blue": [("order_line.product_id", "any", [("name", "ilike", "blue")])]

  Then, the user searches again for products containing "desk": [("order_line.product_id", "any", [("name", "ilike", "blue"),("name", "ilike", "desk")])]

  Finally, the user searches again for products containing "small": [("order_line.product_id", "any", [("name", "ilike", "blue"),("name", "ilike", "desk"),("name", "ilike", "small")])]

   

         Thank you for your guidance.

  Best regards,

        

        

   

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

   

  > [("order_line.product_id.name", "ilike",
  

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

  > 
  

  > 
  

  > I expect to get sales orders only containing the product*Blue xxxsome_elsexx
  

  > Desk*
  

  this expectation is wrong. Your domain evaluates to something like
  

  select id
  

  from sale_order
  

  where
  

  exists (
  

    select id from order_line ...
  

    where .... name like '%blue%'
  

  )
  

  and
  

  exists (
  

    select id from order_line ...
  

    where .... name like '%desk%'
  

  )
  

  so any order having some (not necessarily the same) order line satisfying your 
  

  conditions will be returned.
  

  What you need is the any operator that was introduced in v17:
  

  https://www.odoo.com/documentation/17.0/developer/reference/backend/
  

  orm.html#search-domains
  

   [("order_line.product_id", "any", [("name", "ilike", "blue"),("name", 
  

  "ilike", "desk")])]
  

  and before v17 you were just out of luck trying to express such a condition 
  

  with a domain.
  

  If you also want to exclude orders with order lines not fitting your condition, 
  

  you need to add a "not any" clause.
  

  -- 
  

  Your partner for the hard Odoo problems
  

  https://hunki-enterprises.com
  

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

  ---

  by feihu.zhang - 10:21 - 13 Nov 2024

2 more replies