is possible that many2one fields act as selection?

ecarreras · **Posted:** Mon Aug 20, 2007 1:00 pm

Hi,
I'm trying to do that a many2one field act as a selection field only in the view mode, in the database I want to maintain the relation.

I've tried to do <field name="my_field" widget="selection" /> but, the client raises this error:

File "/home/under/Projectes/TinyERP/tinyerp-client-4.2.0-rc1/bin/widget/model/field.py", line 137, in set
if value in [sel[0] for sel in self.attrs['selection']]:
KeyError: 'selection'

that means in the xml view there are not attribute selection, The possible values must be taken from the relation object.

ecarreras · **Posted:** Mon Aug 20, 2007 1:18 pm

in the definition of the model do:

Code:

'my_field': fields.many2one('mymodule.relation.model', 'Title', selection=_sel_func),

And then define the _sel_func like this (before the fields definitons):

Code:

def _sel_func(self, cr, uid, context={}):
    obj = self.pool.get('mymodule.relation.model')
    ids = obj.search(cr, uid, [])
    res = obj.read(cr, uid, ids, ['name', 'id'], context)
    res = [(r['id'], r['name']) for r in res]
    return res

That's all!

gstabel · **Joined:** Sat Jun 28, 2008 2:04 pm **Posts:** 24

In version 5 (maybe before) this works simply adding a widget="selection" in the xml arch.

In the model columns:

Code:

'my_field': fields.many2one('mymodule.relation.model', 'Title',),

In the xml arch:

Code:

Gabriel C. Stabel

sinoj · **Posted:** Tue Mar 03, 2009 7:09 am

gstabel wrote:

In version 5 (maybe before) this works simply adding a widget="selection" in the xml arch.

In the model columns:

Code:

'my_field': fields.many2one('mymodule.relation.model', 'Title',),

In the xml arch:

Code:

<field>

Gabriel C. Stabel

Thats Good

But I could not see that used anywhere in base OpenERP. Is that widget it officially supported? Its not working on OpenERP Web

sinoj · **Posted:** Tue Mar 03, 2009 7:10 am

@ gstabel
Do you know about any other hidden features on OpneERP? :wink:

rpitorre · **Posted:** Fri Feb 19, 2010 12:24 pm

Hi,
The trick given by gstabel is working well on both web/gtk client. But the "official" way from the doc, given by ecarreras doesn't give a selection. Why ??? :shock:

rpitorre · **Posted:** Fri Feb 19, 2010 6:17 pm

One question : How can we choose the attribute which the selection operates on ? It works with a "name" attribute, but not anymore if I change "name" by "motive" (by example).

rpitorre · **Posted:** Wed Feb 24, 2010 1:11 pm

And one more :wink:

It seems that the domain filter (into the code) is no longer used if there is a widget="selection" on the attribute. Any idea ?
Thx

rpitorre · **Posted:** Wed Mar 03, 2010 7:01 pm

rpitorre wrote:

One question : How can we choose the attribute which the selection operates on ? It works with a "name" attribute, but not anymore if I change "name" by "motive" (by example).

I discovered _rec_name...

rpitorre wrote:

And one more :wink:

It seems that the domain filter (into the code) is no longer used if there is a widget="selection" on the attribute. Any idea ?
Thx

Fixed in 5.0.7 :roll:

supermanu35 · **Joined:** Sat Jan 02, 2010 10:14 pm **Posts:** 3

rpitorre wrote:

And one more :wink:

It seems that the domain filter (into the code) is no longer used if there is a widget="selection" on the attribute. Any idea ?
Thx

Fixed in 5.0.7 :roll:

[/quote]

I always have the problem in 5.0.7.

rpitorre · **Posted:** Mon Mar 08, 2010 10:43 am

Me too! I saw that the bug was fixed here, but it seems it's not working at all. The domain (in .xml or .py) doesn't filter the search with widget="selection".