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

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

ช่วยเหลือ

How to change the default sorting of projects by "End Date"

v7 _inherits _order

1 ตอบกลับ

9837 มุมมอง

Yoshi Tashiro

Must be some basic stuff, but I would like to know how I can sort projects by End Date. I have tried below in an addon module...

from openerp.osv import fields, osv
class project(osv.osv):
    _inherit = 'project.project'
    _name = 'project.project'
    _order = 'date'

And I get this error.

ProgrammingError: column "date" does not exist
LINE 1: ...0, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63) ORDER BY date

I realize that the original project class _inherits "account.analytic.account" which is where the End Date comes from. In such case how can we use a field that belong to the original model in sorting?

Ghanshyam Prajapati

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

Hello, I found the solution, here in project object , it inherits account.analytic.account object. and this 'date' field is made in account.analytic.account object. so we must have to use following method, Try this,

class project(osv.Model):
    _inherit = "project.project"
    _order = 'date2'
    _columns = {
        'date2': fields.related('analytic_account_id', 'date', string="End Date", type='date', store=True),
    }

and no need of _name = 'project.project' so,

remove

_name = 'project.project'

Hope it work for you.

Yoshi Tashiro

ผู้เขียน

I tried your edited content (just remove _name = 'project.project') but I still get the same error as in the original question ("ProgrammingError: column "date" does not exist")...

Ghanshyam Prajapati

Hey Ypshi, see my updated answer. the problem was, date field is made in account.analytic.account object. so we can not order date field directly from project.

Ghanshyam Prajapati

Hey Yoshi, Is your problem is solved?? if yes then please mark my answer as solved. Thanks.

Yoshi Tashiro

ผู้เขียน

I still get the error "ProgrammingError: column project_project.date does not exist". Something must be missing...

Ghanshyam Prajapati

You must have to update your module. Go through Settings >> Modules >> Installed Modules. search your module and upgrade it.

Yoshi Tashiro

ผู้เขียน

I totally forgot to do that. It solved the problem. Then I got another problem of "End Date" being blank (thus the sorting didn't work), so I changed the field name to "date2" for the code to work. Thanks a lot for your advice!

Ghanshyam Prajapati

please mark my answer as solved if your problem is solved. thanks.. :)

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

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

ลงชื่อ

Related Posts	ตอบกลับ	มุมมอง
one2one fields in views แก้ไขแล้ว one2many v7 one2one _inherits	3 ก.พ. 24	13322
How to add a "Delete" button on the popup form? แก้ไขแล้ว v7	1 ต.ค. 25	5597
Minimum Lot Charge For Sales Order Line Items v7	0 ธ.ค. 24	10519
Record Rule to allow a User to update their own Employee object without belonging to Officer group แก้ไขแล้ว v7	3 ก.ย. 24	22988
How to activate the Technical Features? แก้ไขแล้ว v7	5 ธ.ค. 24	55070

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

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