Skip to Content
This question has been flagged
treeviewfieldsort
2 Replies
18857 Views
Avatar
MONEO Tomasz Serwanski

hello,


In stock module, I have 'inventory control' -> 'products'; when switched to list view I can see list as on pisture attached. Problem I have is that I can sort the list using for example 'product type' column (marked green), but cannot sort using 'quantity on hand' nor 'forecasted quantity'. View name used for the list is 'product.template.product.tree'; column 'quantity on hand' and 'forecasted quantity' are inherited from other, 'product.template.stock.tree.inherit'.

How to make fields marked in red on picture, labeled as:

<field name="qty_available"/>

<field name="virtual_available"/>

to be sortable?


regards

Tomasz

Avatar
Discard
Avatar
Esther Martín
Best Answer

That fields are compute fields. By default, they are not stored at database, so you cant sort products by that fields.

You can set them store="True" and thats make it possible to sort on qty on hand of forecast

Avatar
Discard
Ibrahim Boudmir

Indeed, and yet, the more computed fields are in tree view, the more it takes to be fully charged. You should use them wisely.

Avatar
MONEO Tomasz Serwanski
Author Best Answer

 


..and picture attached.
Avatar
Discard
Related Posts Replies Views Activity
Sticky Field Solved
treeview field
Avatar
Avatar
1
Nov 19
2498
how to prevent default sort column for specific condition??
treeview column sort
Avatar
0
Jul 24
136
odoo 8 sort tree view according to workflow states Solved
treeview sort odooV8
Avatar
Avatar
3
May 16
4674
Sale.order TreeView: how to add fields like "partner_shipping_id.city"? Solved
treeview field res.partner shipping
Avatar
Avatar
Avatar
2
Dec 22
6300
[Solved] [Odoo 11] How to add an editable field in a treeview. Solved
treeview editable field odoo11
Avatar
3
Jul 24
21365