How to add query returned value to selection field in odoo 15-CodePudding

i want to add this returned list from get_famille_list function to selection field in odoo-15

get_famille_list function :

def get_famille_list(self):
    all_fam = []
    query = """ SELECT x FROM product_template WHERE x !='' """
    self.env.cr.execute(query)
    data = self.env.cr.fetchall()
    for fam in data:
        all_fam.append(fam[0])
    return all_fam

And this is how i link the selection with the returned list from get_famille_list function

famille = fields.Selection(selection='get_famille_list')

expected data (selection= x1,x2,x3)

insteed of showing the correct data in the selection field it shows something weird, see the image

i can't figure out why it shows this. any help will be appreciated, Thanks

CodePudding user response：

You need to return a list of pairs (value, label).

You just need to append a tuple to the all_fam list

Example:

def get_famille_list(self):
    all_fam = []
    query = """ SELECT x FROM product_template WHERE x !='' """
    self.env.cr.execute(query)
    data = self.env.cr.fetchall()
    for fam in data:
        all_fam.append((fam[0], fam[0].capitalize()))
    return all_fam