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

CRM
e-Commerce
会計
在庫
PoS
プロジェクト
MRP

All apps

全てのポスト人々バッジ

タグ (全て表示)

odoo accounting v14 pos v15

このフォーラムについて

ヘルプ

'on_change' alternative for dynamic domain on form edit

domain on_change v7

5 返信

26126 ビュー

Obay Albadri

I am facing this problem:

"I need to change the domain of a field from within an on_change event handler because it needs special computation. While it works as expected when the field is changed, the event isn't triggered when the value is loaded into the field at form init time."

so i tried: 1. on_change: not called when editing form, and that is reasonable. 2. Just using a domain: i found my domain is more complex and needs special computation. 3. 'fields_view_get': i couldn't get the current values to construct my domain. 4. custom function to get domain: i am too close with this, but have a problem with return type.

So what is the best alternative for on_change, for this case?

here is a summarized code for 'fields_view_get':

def fields_view_get(self, cr, uid, view_id=None, view_type='form', context=None, toolbar=False, submenu=False):
    res = super(taskmng_task, self).fields_view_get(cr, uid, view_id=view_id, view_type=view_type, context=context, toolbar=toolbar, submenu=submenu)
    doc = etree.XML(res['arch'])
    for node in doc.xpath("//field[@name='user_id']"):
        node.set('domain', 'MY DOMAIN') # here i need the current form values (if applicable)
    res['arch'] = etree.tostring(doc)
    return res

Code for custom function:

def _get_user_id_domain(self, cr, uid, ids, field_name, arg, context=None):
    record_id = ids[0] 
    project_id = self.browse(cr, uid, ids, context=context)[0].project_id   # here i can get the values (eg. 'project_id')
    # do some computation....
    return {record_id: "MY DOMAIN"} # returning domain as string rises an exception*

and then i made a field to hold domain value:

'domain_field': fields.function(_get_user_id_domain, type='char', size=255, method=True, string="Domain"),

and i use it in XML:

<xpath expr="//field[@name='user_id']" position="replace">
       <field name="user_id" domain="domain_field" />
</xpath>

*When edit the filed, this exception occur "TypeError: second argument to Function.prototype.apply must be an array", (only if i returned domain as string, and i need to do that!)

Am i going in the wrong direction, and what is the best way to make such a domin?

Obay Albadri

著作者

Sorry for posting all these details, it may solve another question :)

Obay Albadri

著作者

I found a way to avoid returning domain as string in last function, and it works.

Ákos Sebestyén

Can you please share your solution with us?

51anygo

最善の回答

Hello, first,thank you everyone, i get some way to solve the problem from this article , After continuous attempts, i have solved this problem perfect, the way is use onchange and add field with function type, code like this

_columns = {
        'ts_id': fields.many2one('trainstation.trainstation', 'ts', help="",required=True,),
        'get_department_id': fields.function(_get_department_id, type='integer',  method=True, string="Domain"),
        'employee_id': fields.many2one('hr.employee', 'operator', ,required=True),

}

    _defaults = {
    'ts_id':  None,
}


    def _get_department_id(self, cr, uid, ids, field_name, arg, context=None):
    result = {} 
    if not ids:
        return result           
    for record in self.browse(cr, uid, ids, context=context):
        result[record.id] = record.ts_id.area_id.manage_department_id.id
    return result

def onchange_ts(self, cr, uid, ids, ts_id,employee_id, context=None):
    domain = {}
    value =  {}
    if context is None:
        context = {}
    if not ts_id:
        return {'domain':domain}       
    obj_ts = self.pool.get('trainstation.trainstation')
    ts = obj_ts.browse(cr, uid, ts_id, context=context)
    if employee_id:
        obj_emp = self.pool.get('hr.employee')
        emp = obj_emp.browse(cr, uid, employee_id, context=context)         
        if emp.department_id.id == ts.area_id.manage_department_id.id:
            return {'domain':domain}
    domain = {'employee_id':[('department_id','=',ts.area_id.manage_department_id.id)]}
    value = {'employee_id': False}
    return {'value':value,'domain':domain}

 add this to xml file
<field name='ts_id' on_change="onchange_ts(ts_id,employee_id)" />
<field name="get_department_id" invisible="1"/>    
<field name='employee_id'  domain="[('department_id','=',get_department_id)]" />

Jeudy Nicolas

Hello,

We have implemeted this, but you need to patch openerp-server and openerp-web to enable en new setup option in form definition and a new invisible parameter that trigger invisibility state change.

you can find branch we just pushed here:

openerp-server : https://code.launchpad.net/~0k.io/openobject-server/add-setup-to-rng-syntax
openerp-web: https://code.launchpad.net/~0k.io/openerp-web/invisible-keyword-in-onchange-dict

And next if you want to execute onchange like function when form is loaded, just add this to your form definition:

<form string="Project" version="7.0" setup="my_func(name,'test')">
   ...
</form>

and in python, create a function just like onchange one:

class project(osv.osv):
    ...
    def my_func(self, cr, uid, ids, part=False, context=None):
        return {'invisible': {'partner_id': True},  'domain' : {'my_field':[]}}
    ...

Hope this will help.

Obay Albadri

著作者

Thanks, that what i was looking for previously, and this is a good news for me, any way i approached another way (domain via function, and it works now), but i think this is a better way, right?

Anton Chepurov

Anybody to port this to v8?

Adil Akbar

You can follow this: https://youtu.be/XGqXEL2qQmE

Hope it helps, Thanks

Simplify it!

The onchange method works too if you are just defining by default a value. If you set
_defaults = { 'type': 'issue' }
for example.
Automatically system is going to call onchange function when the form loads. I hope that answers your question.

Regards

Keyur

Hi Obay,

Yes ofcourse there is an easy way to apply domain on field from within an on_change event.

Like this,

I have applied domain on the basis of type field. My type field is a selection field of values issue and return. On the basis of type field I am changing the domain of location_id.

def onchange_type(self, cr, uid, ids, type):
    domain = {}
    if type=='issue':
        domain = {'location_id':[('usage','=','internal')]}
    elif type=='return':
        domain = {'location_id':[('usage','=','inventory')]}
    return {'domain':domain}

Hope this solution solve your problem too.

Thanks.

Obay Albadri

著作者

thanks Keyur, but the problem with 'on_change' is that "While it works as expected when the field is changed, the event isn't triggered when the value is loaded into the field at form init time.", that is why i am looking for alternative.

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！

今すぐアカウントを作成して、限定機能を利用したり、素晴らしいコミュニティと交流しましょう！

登録

関連投稿	返信	ビュー
How to Set Fixed Filter for a User / User group ? domain v7	1 8月 15	6631
Change the domain of a many2one field depending on other field value 解決済 domain on_change odoo12	3 3月 24	18034
How can i set team sales permissions in CRM? crm domain v7	5 9月 22	12649
How to update domain set in fields_view_get? 解決済 domain v7 fields_view_get	1 2月 22	26973
How to write a Domain in a filter? [SOLVED] 解決済 filter domain v7	1 4月 24	14802

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！