Hi, I create a tree view based in the sql view, I don't know the source of this error:
Client Traceback (most recent call last): File "/home/openerp/workspace/sankofa/openerp/addons/web/http.py", line 203, in dispatch response["result"] = method(self, **self.params) File "/home/openerp/workspace/sankofa/openerp/addons/web/controllers/main.py", line 1055, in search_read return self.do_search_read(req, model, fields, offset, limit, domain, sort) File "/home/openerp/workspace/sankofa/openerp/addons/web/controllers/main.py", line 1078, in do_search_read req.context) File "/home/openerp/workspace/sankofa/openerp/addons/web/session.py", line 43, in proxy result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw) File "/home/openerp/workspace/sankofa/openerp/addons/web/session.py", line 31, in proxy_method result = self.session.send(self.service_name, method, *args) File "/home/openerp/workspace/sankofa/openerp/addons/web/session.py", line 104, in send raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info) Server Traceback (most recent call last): File "/home/openerp/workspace/sankofa/openerp/addons/web/session.py", line 90, in send return openerp.netsvc.dispatch_rpc(service_name, method, args) File "/home/openerp/workspace/sankofa/openerp/netsvc.py", line 293, in dispatch_rpc result = ExportService.getService(service_name).dispatch(method, params) File "/home/openerp/workspace/sankofa/openerp/service/web_services.py", line 626, in dispatch res = fn(db, uid, *params) File "/home/openerp/workspace/sankofa/openerp/osv/osv.py", line 188, in execute_kw return self.execute(db, uid, obj, method, *args, **kw or {}) File "/home/openerp/workspace/sankofa/openerp/osv/osv.py", line 131, in wrapper return f(self, dbname, *args, **kwargs) File "/home/openerp/workspace/sankofa/openerp/osv/osv.py", line 197, in execute res = self.execute_cr(cr, uid, obj, method, *args, **kw) File "/home/openerp/workspace/sankofa/openerp/osv/osv.py", line 185, in execute_cr return getattr(object, method)(cr, uid, *args, **kw) File "/home/openerp/workspace/sankofa/openerp/osv/orm.py", line 2354, in search return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count) File "/home/openerp/workspace/sankofa/openerp/osv/orm.py", line 4856, in _search cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params) File "/home/openerp/workspace/sankofa/openerp/sql_db.py", line 161, in wrapper return f(self, *args, **kwargs) File "/home/openerp/workspace/sankofa/openerp/sql_db.py", line 226, in execute res = self._obj.execute(query, params) ProgrammingError: relation "transfert_movement" does not exist LINE 1: SELECT "transfert_movement".id FROM "transfert_movement" ORDER BY "transfert_m... ^
My xml code is:
<record id="view_transfert_movement_search" model="ir.ui.view">
<field name="name">transfert.movement.search</field>
<field name="model">transfert.movement</field>
<field name="arch" type="xml">
<search string="transfert movements">
<filter string="No.Transfert" domain="[]" context="{'group_by':'name'}"/>
<filter string="Respo. Chargeur" domain="[]" context="{'group_by':'partner_id'}"/>
<filter string="Chauffeur" domain="[]" context="{'group_by':'material_driver_partner_id'}"/>
<filter string="Camion" domain="[]" context="{'group_by':'material_license_plate'}"/>
<filter string="Date du transfert" domain="[]" context="{'group_by':'date'}"/>
<filter string="Material" domain="[]" context="{'group_by':'product_id'}"/>
<filter string="Source" domain="[]" context="{'group_by':'sourcelocation'}"/>
<filter string="Destination" domain="[]" context="{'group_by':'destinationlocation'}"/>
<filter string="Statut" domain="[]" context="{'group_by':'state'}"/>
</search>
</field>
</record><record id="view_transfert_movement_report_tree_new" model="ir.ui.view">
<field name="name">transfert.movement.tree</field>
<field name="model">transfert.movement</field>
<field name="arch" type="xml">
<tree string="Out movements" create='false'>
<field name="name"/>
<field name="partner_id"/>
<field name="material_driver_partner_id"/>
<field name="material_license_plate"/>
<field name="date"/>
<field name="product_id"/>
<field name="product_qty"/>
<field name="sourcelocation"/>
<field name="destinationlocation"/>
<field name="state"/>
</tree>
</field>
</record>
<record id="action_transfert_movement_report_new" model="ir.actions.act_window">
<field name="name">transfert movements</field>
<field name="res_model">transfert.movement</field>
<field name="view_type">form</field>
<!-- <field name="search_view_id" ref="view_transfert_movement_search"/> -->
<field name="view_mode">tree</field>
</record>
<menuitem name="Mouvements" id="menu_transfert_mouvement_new" parent="menu_material_transfert" action="action_transfert_movement_report_new" sequence="20"/>
and my .py code is:
class transfert_movement(osv.osv):
_name = "transfert.movement"
_description = "transfert movement"
_auto = False
_columns = {
'name': fields.char('No. Transfert', size=128),
'partner_id': fields.many2one('res.partner', 'Respo Chargeur'),
'material_driver_partner_id': fields.many2one('res.partner', 'Chauffeur'),
'material_license_plate': fields.char('Camion', size=128),
'date': fields.date('Date de transfert'),
'product_id': fields.many2one('product.product', 'Material'),
'product_qty': fields.integer('Quantity'),
'sourcelocation': fields.char('Source', size=128),
'destinationlocation': fields.char('Destination', size=128),
'state': fields.selection(
[('draft', 'Draft'),
('cancel', 'Cancelled'),
('auto', 'Waiting Another Operation'),
('confirmed', 'Waiting Availability'),
('assigned', 'Ready to Transfer'),
('done', 'Transferred'),
], 'Status'),
}def init(self, cr):
tools.drop_view_if_exists(cr, self._table)
cr.execute("""CREATE or REPLACE VIEW %s as (select distinct sm.id as id, sp.name, sp.partner_id,
sp.material_driver_partner_id, sp.material_license_plate, sp.date, sm.product_id,
sm.product_qty, sl_source.name as sourcelocation, sl_dest.name as destinationlocation,
sp.state
from
stock_picking sp, stock_move sm, stock_location sl_source, stock_location sl_dest
where
sp.pickingmaterialtype='materialtransfert' and sp.id = sm.picking_id and
sl_dest.id = sm.location_dest_id and sl_source.id = sm.location_id)
""" % (self._table))
Help me please, Thanks...
