Overslaan naar inhoud
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Alle posts Personen Badges
Labels (Bekijk alle)
odoo accounting v14 pos v15
Over dit forum
Deze vraag is gerapporteerd
1 Beantwoorden
6702 Weergaven
Avatar
Zakaria

Hello,

I have created many2many field, which can contain many elements :

capture_ref = fields.Many2many('affichage.information', string="Numéro de série", required=True)

I would like to browse the these elements in order to can apply my search function :

rec = self.env['affichage.information'].search([('reference', '=', self.capture_ref.reference)])
Avatar
Annuleer
Avatar
Giezel Esteves
Beste antwoord

For version 10. You need to declare your many2many field as like this

class Sample1(models.Model):

     _name = 'sample.sample1'

   field = fields.Many2many('sample.sample2', 'sample1_sample2_rel', 'sample1_id', 'sample2_id', string="Sample1 Field")


class Sample2(models.Model):

     _name = 'sample.sample2'

    s2_field = fields.Char(string="Sample2 Field")


#here you need to declare 'sample1_sample2_rel' as your many2many relationship table and the fields belong to that table

from that you can obtain records by using this

self.env.cr.execute('SELECT * from sample1_sample2_rel where sample1_id= %s' % pass_variable_or_value_here)

res = self.env.cr.fetchall()

print 'res', res


I hope this helps.


     


Avatar
Annuleer