Hello all,

Here are two custom views. Both replace the field user_id on the inherited view. Why does the domain work well in the first view but not in the second one?

In both cases, the field user_id is on the model account.analytic.line (timesheet). In the second view, I inherit an already inherited view.

Tree view #1 : domain works well!

<record id="hr_timesheet_line_tree_inherited" model="ir.ui.view">
            <field name="name">hr.timesheet.line.tree.inherited.vtm2</field>
            <field name="model">account.analytic.line</field>
            <field name="inherit_id" ref="hr_timesheet.hr_timesheet_line_tree" />
            <field name="arch" type="xml">
                <field name="user_id" position="replace">
                    <field name="user_id" domain="[('employee_ids', '!=', False)]" 
                       required="1" options="{'no_open': True}" />
                </field>
                
            </field>
        </record>

Form view #2 : domain causes an error!

<record id="view_task_form2_inherited" model="ir.ui.view">
            <field name="name">hr.timesheet.view.task.form2.inherited.vtm2</field>
            <field name="model">project.task</field>
            <field name="inherit_id" ref="hr_timesheet.view_task_form2_inherited" />
            <field name="arch" type="xml">
                <xpath expr="//field[@name='timesheet_ids']//tree/field[@name='user_id']" position="replace">
                    <field name="user_id" required="1" options="{'no_open': True}"
                        domain="[('employee_ids', '!=', False)]" />
                </xpath>

            </field>
        </record>

The error for the view 2 :

2017-02-14 18:12:35,735 9045 INFO odoo-10 odoo.sql_db: bad query: SELECT distinct("user_id") FROM "hr_employee" where "user_id" is not null2017-02-14 18:12:35,736 9045 ERROR odoo-10 odoo.http: Exception during JSON request handling.
Traceback (most recent call last):
  File "/home/odoo-10/odoo-10.0/odoo/http.py", line 638, in _handle_exception    return super(JsonRequest, self)._handle_exception(exception)  File "/home/odoo-10/odoo-10.0/odoo/http.py", line 675, in dispatch    result = self._call_function(**self.params)  File "/home/odoo-10/odoo-10.0/odoo/http.py", line 331, in _call_function    return checked_call(self.db, *args, **kwargs)  File "/home/odoo-10/odoo-10.0/odoo/service/model.py", line 119, in wrapper    return f(dbname, *args, **kwargs)  File "/home/odoo-10/odoo-10.0/odoo/http.py", line 324, in checked_call    result = self.endpoint(*a, **kw)  File "/home/odoo-10/odoo-10.0/odoo/http.py", line 933, in __call__    return self.method(*args, **kw)  File "/home/odoo-10/odoo-10.0/odoo/http.py", line 504, in response_wrap    response = f(*args, **kw)  File "/home/odoo-10/odoo-10.0/addons/web/controllers/main.py", line 862, in call_kw    return self._call_kw(model, method, args, kwargs)  File "/home/odoo-10/odoo-10.0/addons/web/controllers/main.py", line 854, in _call_kw    return call_kw(request.env[model], method, args, kwargs)  File "/home/odoo-10/odoo-10.0/odoo/api.py", line 679, in call_kw    return call_kw_model(method, model, args, kwargs)  File "/home/odoo-10/odoo-10.0/odoo/api.py", line 664, in call_kw_model    result = method(recs, *args, **kwargs)  File "/home/odoo-10/odoo-10.0/odoo/addons/base/res/res_users.py", line 396, in name_search    users = self.search([('name', operator, name)] + args, limit=limit)  File "/home/odoo-10/odoo-10.0/odoo/models.py", line 1508, in search    res = self._search(args, offset=offset, limit=limit, order=order, count=count)  File "/home/odoo-10/odoo-10.0/odoo/addons/base/res/res_users.py", line 326, in _search    access_rights_uid=access_rights_uid)  File "/home/odoo-10/odoo-10.0/odoo/models.py", line 4199, in _search    query = self._where_calc(args)  File "/home/odoo-10/odoo-10.0/odoo/models.py", line 3998, in _where_calc    e = expression.expression(domain, self)  File "/home/odoo-10/odoo-10.0/odoo/osv/expression.py", line 643, in __init__    self.parse()  File "/home/odoo-10/odoo-10.0/odoo/osv/expression.py", line 960, in parse    push(create_substitution_leaf(leaf, ('id', o2m_op, select_distinct_from_where_not_null(cr, field.inverse_name, comodel._table)), model))  File "/home/odoo-10/odoo-10.0/odoo/osv/expression.py", line 426, in select_distinct_from_where_not_null    cr.execute('SELECT distinct("%s") FROM "%s" where "%s" is not null' % (select_field, from_table, select_field))  File "/home/odoo-10/odoo-10.0/odoo/sql_db.py", line 141, in wrapper    return f(self, *args, **kwargs)  File "/home/odoo-10/odoo-10.0/odoo/sql_db.py", line 218, in execute    res = self._obj.execute(query, params)ProgrammingError: column "user_id" does not existLINE 1: SELECT distinct("user_id") FROM "hr_employee" where "user_id...

EDIT #1

I have tried the domain directly on the original view. Ihave disabled my new view. I have updated the module hr_timesheet. Still the same error.