Skip to Content
Menu
You need to be registered to interact with the community.
This question has been flagged
2 Odgovori
20836 Prikazi

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
Opusti
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
Opusti

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

Avtor Best Answer

 


..and picture attached.
Avatar
Opusti
Related Posts Odgovori Prikazi Aktivnost
1
nov. 19
3504
0
jan. 25
1
0
jul. 24
975
3
maj 16
5519
2
dec. 22
7302