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 function is the following:
for report in self.browse(cr,uid,ids,context=context):
cr.execute("select create_date from ch14_reports where id=%s",[id])
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
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
|Asked: 8/15/14, 6:09 AM|
|Seen: 1608 times|
|Last updated: 3/16/15, 8:10 AM|