İçereği Atla
Bu soru işaretlendi
developmentmany2manysql
2 Cevaplar
31247 Görünümler
Avatar
Jason Wu

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
Vazgeç
Avatar
Hilar Andikkadavath
En İyi Yanıt

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
Vazgeç
Avatar
Sourav Thachaat
En İyi Yanıt

test=[]

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

try this

Avatar
Vazgeç
Sourav Thachaat

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

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

but the result is none

İlgili Gönderiler Cevaplar Görünümler Aktivite
Only ID is visible in Many2Many Field on a Form Çözüldü
development many2many technical v17
Avatar
Avatar
1
Şub 24
1303
Connecting 2 Many2many Fields Çözüldü
development many2many developer Odoo13
Avatar
1
Eki 20
9367
Should I use 'manual' attribute for many2many relationship with custom table?
development one2many many2many related
Avatar
0
Mar 15
5605
New Model - Cannot find field
development database many2many model
Avatar
0
Mar 15
6706
Change position chatter Çözüldü
development
Avatar
Avatar
1
Ağu 25
150