Comment 54 for bug 1073087

Revision history for this message
Carlos Pueyo (cpueyo) wrote :

I found a solution for this. I not tested all permissions but for now, is working.

File: openerp/osv/expression.py
Line No: 1196

Overwrite: return query, params
For:

# ALCA - Modificado el 15/04/2013
        if query == 'FALSE':
            return 'TRUE', params
        else:
            return query, params

I don't know why, but if the leaf don't have value, and are operator 'in', this function return FALSE and make the STRING SQL with ' AND FALSE' and don't work.

The user admin work because it's hardcode. if superadmin all ok.