This question has been flagged
3204 Views

Hello All,

I have created a new model "my.project" which inherits from project.project model.

class my_project(models.Model):
    _name = "my.project"   
    _inherits = {'project.project':'project_id'}
   
   
    project_id = fields.Many2one('project.project', 'Project', ondelete="cascade", required=True)
    is_approved = fields.Boolean(string='Is Valid Project')
    manger_amt = fields.Float(string='Approval Amt')
    approval_note = fields.Char(string="Approval Note", size=32)

When I create a new record in the form and click on the Save button, I got this error:

File "/home/nirav/OpenERP/odoo/openerp/sql_db.py", line 235, in execute
    res = self._obj.execute(query, params)
ProgrammingError: invalid reference to FROM-clause entry for table "project_project"
LINE 2: ...project_id" = "my_project__project_id"."id") AND ("project_p...
                                                             ^
HINT:  Perhaps you meant to reference the table alias "my_project__project_id".

Thank you.

Avatar
Discard

Please check that the field project_id introduced by you is included in form view or not ? If not check after adding it.

Author

I found one solution if we use other user like "demo" that time work find. But we use "Admin" that time is not working.

Check my suggestion.

Author

Sorry Dear it is not working..