I added a field (Internal Reference) to the Products list view via the GUI interface (Manage Views). Is it possible to make this field sortable via the GUI, or does it require a custom module?
This is because of product variants and the tree view is a list of product.product objects (variants), that column is a related field on the product.template (the parent product of the variants), you can't by default sort by related fields, so this problem is quite specific to the internal reference on the products list view.
To fix this you need to write a function called _generate_order_by on the product object (or override the product object to add that function)
There is some discussion of it here including some code for a similar field http://stackoverflow.com/questions/15621013/sorting-openerp-table-by-functional-field/15621014
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
|Asked: 10/16/14, 2:43 PM|
|Seen: 717 times|
|Last updated: 1/20/16, 6:04 AM|