Skip to Content
This question has been flagged
dateunkownilikelike
1 Atsakyti
4809 Rodiniai
Portretas
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.

Portretas
Atmesti
Portretas
Ben Bernard
Best Answer

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

 

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

Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
odoo 16 dashboard select specific date range Solved
date
Portretas
Portretas
Portretas
3
birž. 25
1216
How to get Creation Date for created Customer? Solved
date
Portretas
Portretas
1
saus. 25
18033
How to calculate total days between count_start and count_end? Solved
date
Portretas
Portretas
1
saus. 20
4005
How to give the specific date like "2022-12-31",not the default date as today? Solved
date
Portretas
Portretas
1
gruod. 19
6468
How to compare with the date that which one is earlier,which one is late? Solved
date
Portretas
Portretas
1
gruod. 19
17357