Skip to Content
This question has been flagged
dateunkownilikelike
1 Reply
5162 Views
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
Discard
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
Discard
Related Posts Replies Views Activity
odoo 16 dashboard select specific date range Solved
date
Avatar
Avatar
Avatar
3
जून 25
2480
How to get Creation Date for created Customer? Solved
date
Avatar
Avatar
1
जन॰ 25
18981
How to calculate total days between count_start and count_end? Solved
date
Avatar
Avatar
1
जन॰ 20
4801
How to give the specific date like "2022-12-31",not the default date as today? Solved
date
Avatar
Avatar
1
दिस॰ 19
7324
How to compare with the date that which one is earlier,which one is late? Solved
date
Avatar
Avatar
1
दिस॰ 19
18122