Ir al contenido
Menú
Se marcó esta pregunta
9 Respuestas
52752 Vistas

How can I create, update or delete values for a selection field?

For example, a selection field has allowable values: value1, value2

How can I add value3?

Avatar
Descartar
Autor

How can I do this in the SaaS instance?

Luigi, unfortunately, AFAIK, you cannot do any of those answers in SaaS instance. You need to do some development.

You can, alternatively, create a new selection field to capture the 3rd (and 4th, etc.) selection. But it will be informational only.

Mejor respuesta

There are 3 ways to provide selection list values that is accepted by OpenERP:

  1. Specifying directly in the field.selection definition: 'field_1': fields.selection([('value1', 'String 1'), ('value2', 'String 2')], 'Field Label')
  2. Specifying using a name list variable outside of the field.selection definition: 'field_1': fields.selection(LIST_VARIABLE, 'Field Label').  Where LIST_VARIABLE is defined beforehand: LIST_VARIABLE = [('value1', 'String 1'), ('value2', 'String 2')]
  3. Specifying using a method: 'field_1': fields.selection(_method_name, 'Field Label').  Where _method_name is defined beforehand:

def _method_name(self, cr, uid, context=None):

    return [('value1', 'String 1'), ('value2', 'String 2')]

Now, you need to check first which one is your current selection field is.  If it is using method No. 1, then you need to redefine it to use either method No 2 or method No 3.  If it is using method No. 2 or 3, you just need to change either the variable (you can use LIST_VARIABLE.append(('value3', 'String 3'))) to return the new value.

Avatar
Descartar
Mejor respuesta

Selection field allows static value in list of tuples

    registration_state = fields.Selection([('select_1', 'One'), ('select_2', 'Two'), ('select_3', 'Three')], 'Select')

in that you can not add values.

so the solutions is to add a many2one field, which allows you to add value in it.  for that you need to define a new model of your selection.

class selection_selection(models.Model):
    _name = 'selection.selection'
    
    name = fields.Char('Name', required=True)
    value = fields.Char('Value', required=True)
    
now in your class you need to add many2one field which is referencing to your selection model like,

class your_model(models.Model):

    _name = 'your.model'
    
    my_selection = fields.Many2one(selection.selection, Selections)
    
now in xml file while defining the fields you need to add a widget to your selection field like,

    <field name="my_selection" widget="selection" />


to configure the selections you can make menu under configuration as per your need.

hope this helps.

Avatar
Descartar

@Atul you can make selection field to have a somewhat dynamic (can be changed by other modules) list of values as I've stated in my answer. Also (and thus), the choice of using either many2one and selection fields does not only lies on the capability to add values. Further details on the differences between many2one and selection fields are elaborated in my answer here: https://www.odoo.com/forum/help-1/question/best-practices-as-to-when-to-use-fields-selection-vs-fields-many2one-69262

Obviously we can make it dynamic selection field. Thanks for the comment @Ivan.

Mejor respuesta

Hi Luigi,

There are two kinds of "selection" fields, so there are two ways that the values are managed.

The one that is defined as "fields.selection(...)" [defined in the .py file, the model] has values defined there in a comma seperated list.  In this case you add the new value to the list in the .py file.

Or a field can be defined as a one to many2one(...), in which case the line that defines it in the .py file will indicate what table has the values. Usually use can add new values from the interface on this type of field.

 

 

Avatar
Descartar
Mejor respuesta

you can use list to add item dynamically in fields.Selection

cnt=0
list1=[]
for i in range(1900,2017):
         list1.append((str(cnt),str(i)))
         cnt=cnt+1

class Employee(models.Model):

    _name = 'employee.details'
    year=fields.Selection(list1, string='Years', required=True, copy=True)

Avatar
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
4
dic 23
21818
5
jul 24
15117
1
jun 22
26584
0
jul 20
2665
0
mar 20
3433