跳至內容
此問題已被標幟
developmentmany2manysql
2 回覆
31278 瀏覽次數
頭像
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 ....


頭像
捨棄
頭像
Hilar Andikkadavath
最佳答案

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

頭像
捨棄
頭像
Sourav Thachaat
最佳答案

test=[]

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

try this

頭像
捨棄
Sourav Thachaat

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

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

but the result is none

相關帖文 回覆 瀏覽次數 活動
Only ID is visible in Many2Many Field on a Form 已解決
development many2many technical v17
頭像
頭像
1
2月 24
1314
Connecting 2 Many2many Fields 已解決
development many2many developer Odoo13
頭像
1
10月 20
9399
Should I use 'manual' attribute for many2many relationship with custom table?
development one2many many2many related
頭像
0
3月 15
5650
New Model - Cannot find field
development database many2many model
頭像
0
3月 15
6723
odoo18 ValueError: Wrong value for ir.ui.view.type: 'tree' in Docker 已解決
development
頭像
頭像
1
8月 25
61