Skip to Content
This question has been flagged
dateunkownilikelike
1 Respondre
4734 Vistes
Avatar
Sandro Regis

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.

Avatar
Descartar
Avatar
Ben Bernard
Best Answer

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

 

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

Avatar
Descartar
Related Posts Respostes Vistes Activitat
odoo 16 dashboard select specific date range Solved
date
Avatar
Avatar
Avatar
3
de juny 25
998
How to get Creation Date for created Customer? Solved
date
Avatar
Avatar
1
de gen. 25
17896
How to calculate total days between count_start and count_end? Solved
date
Avatar
Avatar
1
de gen. 20
3871
How to give the specific date like "2022-12-31",not the default date as today? Solved
date
Avatar
Avatar
1
de des. 19
6300
How to compare with the date that which one is earlier,which one is late? Solved
date
Avatar
Avatar
1
de des. 19
17234