Skip to Content
This question has been flagged
developmentmany2manysql
2 Replies
33877 डेटा देखने का तरीका
अवतार
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
Best Answer

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
Best Answer

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

Related Posts Replies डेटा देखने का तरीका ऐक्टिविटी
Should I use 'manual' attribute for many2many relationship with custom table?
development one2many many2many related
अवतार
1
मई 26
7795
Tax_id field many2many Solved
development product many2many studio
अवतार
अवतार
अवतार
अवतार
अवतार
4
दिस॰ 25
1406
Only ID is visible in Many2Many Field on a Form Solved
development many2many technical v17
अवतार
अवतार
1
फ़र॰ 24
2873
Connecting 2 Many2many Fields Solved
development many2many developer Odoo13
अवतार
1
अक्तू॰ 20
11382
New Model - Cannot find field
development database many2many model
अवतार
0
मार्च 15
8351