Contributors mailing list archives
contributors@odoo-community.org
Browse archives
Real time GPS tracker
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+)
by
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,
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
Reference
-
Assistance Needed: Searching for Specific Products in Sales Orders (Odoo CE 17.0+)
byfeihu.zhang-
回复: Assistance Needed: Searching for Specific Products in Sales Orders (Odoo CE 17.0+)
byfeihu.zhang -
Re: Assistance Needed: Searching for Specific Products in Sales Orders (Odoo CE 17.0+)
byMoaHub, Graeme Gellatly -
Re: 回复: Assistance Needed: Searching for Specific Products in Sales Orders (Odoo CE 17.0+)
byHolger Brunn -
回复: Assistance Needed: Searching for Specific Products in Sales Orders (Odoo CE 17.0+)
byfeihu.zhang -
回复: Assistance Needed: Searching for Specific Products in Sales Orders (Odoo CE 17.0+)
byfeihu.zhang -
Re: Assistance Needed: Searching for Specific Products in Sales Orders (Odoo CE 17.0+)
byMoaHub, Graeme Gellatly -
Re: Assistance Needed: Searching for Specific Products in Sales Orders (Odoo CE 17.0+)
byHolger Brunn
-