Odoo Help


How to remove certain columns from an inherited model?

Marie Pinto
on 9/16/15, 12:59 PM 2,096 views

I'm trying to create a model named 'mantenimiento' based on project.task, but want to omit one or two columns from it.

I have this so far:

 _name = "project.mantenimientos" 
_description = "Mantenimientos"
_inherit = 'project.task'

How could I do it?



Axel Mendoza

--Axel Mendoza--
| 7 8 8
Camaguey, Cuba
--Axel Mendoza--

DevOps - Full stack - Software Architect - Developer - Technology Integrator

I could help you to develop anything and solve complex problems based on technologies, integrations and tricky stuffs mostly in Python with OpenERP/Odoo, Zato, Django and many others frameworks programming languages and technologies.

I offers consulting services to anyone with an unanswered questions or needs for customizations. Think about it, maybe it's better to have an expert to solve your issues and projects than having a full-time employee trying to understand what to do and how

Reach me at aekroft@gmail.com

Axel Mendoza
On 9/16/15, 1:40 PM

You need to define those fields as function fields in your model to don't get created in your table.

Good trick. But in this case the field definition stays there in the model. And it might confuse tools that use the registry.

In this case it is prototype inheritance. A cleaner way would be if odoo allows specify the fields to exclude from the source model. Ex:

_inherit = {'project.task': {'exclude': ['fieldA', 'fieldB', ....]} }

Yurdik Cervantes Mendoza
on 11/18/17, 7:48 AM

Anil R. Kesariya

--Anil R. Kesariya--
| 6 5 8
Rajkot, India
--Anil R. Kesariya--

Odoo Techno Functional Expert

* Engaged with odoo since May - 2012.

* Customise existing module or develop new module base on customer requirement.

* Played key developer role in many past and running projects.

* Expert in requirement gathering of business and transforming requirement into odoo platform.

* Major expertise in core modules, database, report development and theme development.

* Integration expert.

Linkedin  : https://in.linkedin.com/in/anil-kesariya-97b20a66

Anil R. Kesariya
On 9/17/15, 2:35 AM

Hi Marie Pinto,

There are two possiblities to remove columns.

1) Easier way: Either inherit view and just invisible those columns which you don't want to show to user.

2) little tricky: override def init(self, cr): method of this model and execute query to drop columns by altering table as suggest by vivek.

  Risk factor in second step : If your are altering the table and removing any columns from table make sure those fields are not used in any views you have to remove it from there. if those fields are used in any base module view you have to replace it by inheriting views.

Hope this would clear more idea.



On 9/16/15, 1:58 PM

There is not any way for delete columns using _inherit. You need to remove column from database(postgres) using alter table.

You need to execute query for drop column like : alter table project_mantenimientos drop column specific_column.

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: 9/16/15, 12:59 PM
Seen: 2096 times
Last updated: 9/18/15, 2:08 AM