Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
I create a many2one relationship to view the field referred(crm.lead) in Reference/Description(sale.order) as follows,
'client_order_ref': fields.many2one('crm.lead.referred','Reference/Description', copy=False),
but it cause the following error when i click the Reference?Description field,
File "/home/amz02/Projects/odoo/odoo-8.0-647afdf/openerp/sql_db.py", line 234, in execute res = self._obj.execute(query, params) ProgrammingError: relation "_unknown" does not exist LINE 1: SELECT "_unknown".id FROM "_unknown" ORDER BY "_unknown"."id...
Any1 can help me,,,,
Hi, I am not aware object named 'crm.lead.referred'. What i assume is 'referred' is a field in 'crm.lead' object. So if you want to get the value go for related field.
'opportunity_id': fields.many2one('crm.lead','Opportunity Reference', required=True),
'client_order_ref': fields.related('opportunity_id', 'referred', type='many2one', readonly=True, string='Reference/Description')
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
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.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 1/5/15, 11:46 PM|
|Seen: 967 times|
|Last updated: 3/16/15, 8:10 AM|