Problem on search view ????

Question

Hello,

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 ty

kais dkhili · Answer

Thanx for your answer but it is an str

Ludo - 21South · Answer

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

Această întrebare a fost marcată

Enjoying the discussion? Don't just read, join in!