Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

إدارة علاقات العملاء
e-Commerce
المحاسبة
المخزون
PoS
المشروع
MRP

All apps

كافة المنشورات الأفراد الشارات

علامات التصنيف (عرض الكل)

odoo accounting v14 pos v15

حول هذا المنتدى

المساعدة

psycopg2.errors.UndefinedTable: relation "product_product_res_config_settings_rel" does not exist Odoo 15

settings many2many v15

3 الردود

10013 أدوات العرض

fudo

In odoo 15, i got the issue after trying to create Many2many field in settings:

psycopg2.errors.UndefinedTable: relation "product_product_res_config_settings_rel" does not exist

My code:

from odoo import api, fields, models
from ast import literal_eval

class SchoolSettings(models.TransientModel):
    _inherit = 'res.config.settings'

    product_default = fields.Many2many('product.product', string='Default Product')

    @api.model
    def get_values(self):
        res = super(SchoolSettings, self).get_values()
        if self.env['ir.config_parameter'].sudo().get_param('school.school_default_teacher'):
            product_default = self.env['ir.config_parameter'].sudo().get_param('school.product_default')
            res.update(
                product_default=[(6, 0, literal_eval(product_default))]
            )

        return res


    def set_values(self):
        super(SchoolSettings, self).set_values()
        self.env['ir.config_parameter'].set_param('school.product_default', self.product_default.ids)

Xml:

<div class="content-group">

    <label string="Default Product" for="product_default"/>

    <field name="product_default" widget="many2many_tags"/>

</div>

Please help, thanks.

Sehrish

many2many field in Odoo: https://learnopenerp.blogspot.com/2018/12/add-domain-on-many2many-field-in-odoo.html

fudo

الكاتب أفضل إجابة

I've found the answer based on "Kiran K" answer:

from odoo import api, fields, models
from ast import literal_eval

class SchoolSettings(models.TransientModel):
    _inherit = 'res.config.settings'

    # many2many will give you multiselect options, when many2one only give you select option
    # to use many2many, we must declare the middle table to connect 2 tables together.
    # in this example, i create a new table named 'config_product_rel'
    # with 2 column connect 2 table that is 'id' for the 'ir_config_parameter' table
    # and 'product_id' for 'product_product' table
    product_default_many2many = fields.Many2many('product.product', 'config_product_rel', 'id', 'product_id',
                  'Default Product Many2many')

    @api.model
    def get_values(self):
        res = super(SchoolSettings, self).get_values()

        # set values for many2many field
        if self.env['ir.config_parameter'].sudo().get_param('school.product_default_many2many'):
            product_default_many2many = self.env['ir.config_parameter'].sudo().get_param('school.product_default_many2many')
            res['product_default_many2many'] = [(6, 0, literal_eval(product_default_many2many))]

        return res


    def set_values(self):
        # get values for many2many field
        self.env['ir.config_parameter'].set_param('school.product_default_many2many', self.product_default_many2many.ids)

Thanks.

Kiran K

Hi fudo,

Try,

class ResCompany(models.Model):
    _inherit = 'res.company'

    def _active_products(self):
        return self.env['product.product'].search([]).ids

    product_ids = fields.Many2many('product.product', 'company_product_rel', 'company_id', 'product_id',
                  'Default Product',default=_active_products)


class ResConfigSettings(models.TransientModel):
    _inherit = 'res.config.settings'

    product_ids = fields.Many2many(related='company_id.product_ids', relation='product.product', readonly=False)

Hope it helps,
Kiran K

fudo

الكاتب

thanks you sir, but your answer is way too much for what i asking.

fudo

الكاتب

I've post my answer above based your answer, thanks you for helping me.

Kiran K

https://www.cybrosys.com/blog/how-to-save-many2many-field-in-odoo-13-settings

fudo

الكاتب

thanks you sir.

Bryan Sandoval

Lo definí así y funciono.

classProductWizard(models.TransientModel):

_name = "product.wizard"

_description = "See all Products and warehause"

pricelist_ids = fields.Many2many(comodel_name='product.pricelist', string='Pricelist', required=True)

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!

أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!

تسجيل

المنشورات ذات الصلة	الردود	أدوات العرض
many2many restrict selection [odoo15] many2many v15	0 سبتمبر 22	2470
how to use special comand for manymany fields many2many v15	1 يوليو 22	2789
choose an attachment from ir.attachment attachment many2many v15	0 فبراير 23	157
Implicit/canonical naming of many2many relationship table is not possible when source and destination models are the same تم الحل many2many relational v15	1 يوليو 22	6283
Upon pressing save in a wizard, populate a many2many field wizard many2many v15	0 يوليو 22	2916

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!