Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

search record lines details

By
Prakash
on 9/16/13, 4:22 AM 1,560 views

Is it possible in the Sales order header search box to add Sales Lines fields data For example sale line details Product, description, qty to add in the sale order search box. If possible please give me idea. Thanks

0
fisher
On 9/20/13, 1:45 PM

go to settings->user interface->views, locate to the view sale.order.list.select, type search. add the following new search field <field name="order_line" string="Product name Desc" filter_domain="['|',('order_line.product_id.name','ilike',self),('order_line.product_id.description','ilike',self)]"/>

go to sales order list view, type the search text into search box, system will prompt dropdown list by which you can choose search on the "product name Desc" field, based on the same logic, you can search on other related one2many fields by revising the search view accordingly.

0
Trung
On 9/16/13, 5:23 AM

You can see Order Lines To Invoice and search for Order Lines from there. Uncheck "Uninvoiced" to show all lines.

0
Pinakin Nayi (pna)
On 9/16/13, 8:25 AM

Hello ,

I think Its not exactly possible but yes, you can go through Advance search.

In that select Order line and set operator as 'contain' and write anything means product name,description or etc.

So, i think you can search.

Thanks for reply i added using Related Fields

Prakash
on 9/16/13, 9:12 AM

HOw can you do that ?

Trung
on 9/16/13, 9:15 AM

In sale.order object inherit added the below line 'product_id' : fields.related('order_line', 'product_id', type="many2one", relation="product.product", string="Product"), And sale Order search xml view field product id added. Now in sale order screen search box product list shown

Prakash
on 9/16/13, 9:40 AM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

Asked: 9/16/13, 4:22 AM
Seen: 1560 times
Last updated: 3/16/15, 8:10 AM