Odoo Help

Welcome!

This community 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.

0

field date and ilike operator problems

By
Sandro Regis
on 7/22/14, 6:57 PM 776 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.

1

Ben Bernard

--Ben Bernard--
1083
| 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>

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

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