Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

ลูกค้าสัมพันธ์
e-Commerce
ระบบบัญชี
สินค้าคงคลัง
PoS
โปรเจกต์
MRP

All apps

All Posts คน เหรียญรางวัล

แท็ก (View all)

odoo accounting v14 pos v15

เกี่ยวกับฟอรั่มนี้

ช่วยเหลือ

Internal reference column sortable

treeview column odoo8.0 sortable

3 ตอบกลับ

10967 มุมมอง

Roberto Barreiro

I added the column "internal reference" to the "product.template.product.tree" view. Unfortunately, this column is not sortable. Is there any way to make it sortable? Thanks in advice.

Here is the code of my custom view:

<openerp>
    <data>
        <record id="product_template_tree_view_custom_fields" model="ir.ui.view">
            <field name="name">product.template.tree.view.custom.fields</field>
            <field name="model">product.template</field>
            <field name="type">tree</field>
            <field name="inherit_id" ref="product.product_template_tree_view"/>
            <field name="arch" type="xml">
                <field name="name" position="before">
                    <field name="default_code"/>
                <field>
            </field>
        </record>
    </data>
</openerp>

Deepa Venkatesh

คำตอบที่ดีที่สุด

I guess the column "internal reference" which you have added is either a related or computation field, which is not saved to database, if yes then sorting will not happen.

Sorting is a property availed from database, hence you can perform sorting action only on those columns which are actually present/stored into the database.

By default all the basic data-type columns (such as Char, Float etc) will be physically created into the table except for related & computation fields, for which one need to store it explicitly into the database by adding the property "store=True" against the field in PyObject/Class.

Roberto Barreiro

ผู้เขียน

The field named "internal reference" it's stored on database, on the table "product_product". On the interface of odoo, the label of this field is "internal reference", but at database the name it's "default_code". The type of the field is "character varying". Thank you.

Roberto Barreiro

ผู้เขียน

Server restarted and your solution works! Thank you very much!

Roberto Barreiro

ผู้เขียน

You are right, now I saw the field default_code on the product_template model, it's a related field to the product_product model. As you said, solved with parameter store=True.

class product_template(osv.osv):

_inherit = 'product.template'

_columns = {

'default_code': fields.related('product_variant_ids', 'default_code', type='char', string='Internal Reference', store=True),

}

P.V.Anthony

I am new to this. Could I have the steps to where I can place the above code in odoo?

Roberto Barreiro

ผู้เขียน

The code it's placed on a customized module. Take a look at this addon, this code belongs to it:

https://www.odoo.com/apps/modules/9.0/product_tree_view_internal_reference_sortable/

P.V.Anthony

Thank you very much for sharing this module. It is exactly what is needed. This module will help us save much time. Thank you again for sharing the module.

Al Mazaj - Mahba

Hi,

am not a developer, will i be able with some steps to perform what you mentioned above ?

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!

สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!

ลงชื่อ

Related Posts	ตอบกลับ	มุมมอง
How display invoice lines items in tree view - Odoo8 treeview odoo8.0	1 ก.ค. 19	4178
how to prevent default sort column for specific condition?? treeview column sort	0 ก.ค. 24	1713
add standard_price in tree view in inventory report Odoo14 CE treeview column add	2 เม.ย. 21	4743
Odoo10: how display different values in one odoo tree column treeview tree column	0 มี.ค. 17	3615
Changing column widths tree view แก้ไขแล้ว treeview column css width	11 ต.ค. 24	102276

คำถามนี้ถูกตั้งค่าสถานะ

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!