Odoo Help


Why when I create one field in sale.py it is not created in Postgresql database?

on 2/29/16, 8:12 AM 556 views

I have a problem because when I create a field in sale.order.line model. This field does not appear in the database Postgresql when I make a query in sale_order_line.

This is the statement I created field in the model sale.order.line :

niu = fields.Char(string="NIU", compute="_niu_validation", default=" ", readonly=True)

Please if anyone could help me , I'll be very grateful. Thank you for your time and dedication.

Axel Mendoza
On 2/29/16, 8:18 AM

Hi @beriliox

That's is a computed field that it's not stored in the database, if you wanna store the result of the computation you need to add the argument store=True to the field definition, like:

niu = fields.Char(string="NIU", compute="_niu_validation", default=" ", readonly=True, store=True)

Thanks, but now Odoo shows me the following error: ProgrammingError: column "niu" of relation "sale_order_line" does not exist LINE 1: ...roduct_id", "product_packaging", "qty_delivered", "niu", "cr...

on 2/29/16, 8:31 AM

You need to restart the Odoo server and update your module for Odoo convert the computed field into an store one

Axel Mendoza
on 2/29/16, 8:34 AM

Thanks. I do it ;)

on 2/29/16, 8:59 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 2/29/16, 8:12 AM
Seen: 556 times
Last updated: 2/29/16, 8:22 AM