Odoo Help


Problem on search view ????

kais dkhili
on 8/14/14, 10:27 AM 921 views


i want to make a search view; but i have a problem when my search is based on the following field:

'reports_datecreation' :fields.function(_getcreatedate, method=True, type='char', string='le', store=True),

the ERROR is the Following:

ProgrammingError: operator does not exist: timestamp without time zone ~~* unknown LINE 1: ...ch14_reports" WHERE ("ch14_reports"."create_date" ilike ' ... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

Can someone tell me what'is wrong ? the field saved is : 2014-08-14 16:20:38.546581 her type is char

kais dkhili
On 8/14/14, 10:39 AM

Thanx for your answer but it is an str


Ludo - 21South

--Ludo - 21South--
| 2 2 5
Zwijndrecht, Netherlands
--Ludo - 21South--


Ludo - 21South
On 8/14/14, 10:34 AM

The return of your "_getcreatedate" method is most likely not a string, but something like a datetime object?

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: 8/14/14, 10:27 AM
Seen: 921 times
Last updated: 3/16/15, 8:10 AM