Odoo Help


field date and ilike operator problems

Sandro Regis
on 7/22/14, 6:57 PM 1,230 views

Hello friends, i have a table column with date type and at my view once i set the domain rules it doesn't works throws exception: openerp.netsvc: ERRO:  operator doesn't exists: date ~~* unknown
LINE 1: ...n_month" WHERE (report_commission_month."in_date" ilike '2014/07'...

Below my line of xml file:
<field name="domain">[('in_date','=ilike',time.strftime('%Y/%m'))]</field>

Thank you all for some hint on how to solve this.


Ben Bernard

--Ben Bernard--

| 4 3 6
Jakarta, Indonesia
--Ben Bernard--
Ben Bernard
On 7/22/14, 9:19 PM

Don't need '=' in second tuple for operator.


    <field name="domain">[('in_date','ilike',time.strftime('%Y/%m'))]</field>

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 7/22/14, 6:57 PM
Seen: 1230 times
Last updated: 3/16/15, 8:10 AM