Passa al contenuto
Menu
È necessario essere registrati per interagire con la community.
La domanda è stata contrassegnata
2 Risposte
31512 Visualizzazioni

Dears:

my env is odoo V8 

i have many2many fields.. 

orders_id = fields.Many2many('mrp.production', relation='mrp_rel_mo')
order_list = self.env.cr.execute('select mrp_production_id from mrp_rel_mo where mrp_rel_mo_id = %s', (self.id))
data = {
     "order_list" = self.env.cr.fetchall()
}

but can't get order_list data....allways is None ....


Avatar
Abbandona
Risposta migliore

Hi,

Please check table in pg admin and ensure the data is available. then try to execute the same query on the psql pan, this would helps to clear your doubts.

Update dict 'data' as

data = {

     "order_list" : order_list.fetchall()

}


Thanks

Avatar
Abbandona
Risposta migliore

test=[]

self._cr.execute('select selecting filed from table name )
test.append(self._cr.fetchone())

try this

Avatar
Abbandona

temp_value= self._cr.execute('select * from std_table_print')

data={ "temp_value":temp_value.fetchall() }

but the result is none

Post correlati Risposte Visualizzazioni Attività
1
feb 24
1410
1
ott 20
9582
0
mar 15
5787
0
mar 15
6841
2
ago 25
236