Odoo Help

Welcome!

This community 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.

0

ProgrammingError: operator does not exist: timestamp without time zone" Error on search view

By
kais dkhili
on 8/15/14, 6:09 AM 1,781 views

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 function is the following:

def _getcreatedate(self,cr,uid,ids,name,args,context=None):
        date=''
        res={}
        id=ids[0]
        for report in self.browse(cr,uid,ids,context=context):
            cr.execute("select create_date from ch14_reports where id=%s",[id])
            r=cr.fetchone()
            date=r[0]
            res[report.id]=date
        return res

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

Change type in function field to 'date'.

Ben Bernard
on 8/15/14, 6:34 AM

Bernard there is no changes

kais dkhili
on 8/15/14, 6:55 AM

Bernard there is no changes

kais dkhili
on 8/15/14, 6:56 AM

restart? I'm sorry to ask, but python is not ruby or php.

Ben Bernard
on 8/15/14, 7:16 AM
0

Serpent Consulting Services Pvt. Ltd.

--Serpent Consulting Services Pvt. Ltd.--
4341
| 6 6 8
Gandhinagar, India
--Serpent Consulting Services Pvt. Ltd.--

Serpent Consulting Services Pvt. Ltd. Your Odoo/OpenERP Solution, just an email away!

Serpent Consulting Services Pvt. Ltd.
On 8/15/14, 8:42 AM

Kais,

cr.execute("select create_date from ch14_reports where id=%s",[id])

Should be

cr.execute("select create_date from ch14_reports where id=%s",id)

OR

cr.execute("select create_date from ch14_reports where id=%s" % id)

Thanks.

Your Answer

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

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

Asked: 8/15/14, 6:09 AM
Seen: 1781 times
Last updated: 3/16/15, 8:10 AM