Przejdź do zawartości
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
Wszystkie posty Osoby Odznaki
Tagi (Zobacz wszystko)
odoo accounting v14 pos v15
O tym forum
To pytanie dostało ostrzeżenie
developmentmany2manysql
2 Odpowiedzi
33806 Widoki
Awatar
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 ....


Awatar
Odrzuć
Awatar
Hilar Andikkadavath
Najlepsza odpowiedź

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

Awatar
Odrzuć
Awatar
Sourav Thachaat
Najlepsza odpowiedź

test=[]

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

try this

Awatar
Odrzuć
Sourav Thachaat

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

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

but the result is none

Powiązane posty Odpowiedzi Widoki Czynność
Should I use 'manual' attribute for many2many relationship with custom table?
development one2many many2many related
Awatar
1
maj 26
7654
Tax_id field many2many Rozwiązane
development product many2many studio
Awatar
Awatar
Awatar
Awatar
Awatar
4
gru 25
1384
Only ID is visible in Many2Many Field on a Form Rozwiązane
development many2many technical v17
Awatar
Awatar
1
lut 24
2839
Connecting 2 Many2many Fields Rozwiązane
development many2many developer Odoo13
Awatar
1
paź 20
11360
New Model - Cannot find field
development database many2many model
Awatar
0
mar 15
8327